MySQL has a number of built-in text functions to aid in the searching and mianipulation of text or string data. You can combine data from multiple columns or look for the occurence of a particular character or grup of characters within a string. You can also do basic text analaytics with word counts and lengths.
The tutorial below introduces common text functions and their usage.
Creating Databases and Loading Data