MySQL Text Functions

Manipulating Data with Text Functions

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.

You may also be interested in:

Creating Databases and Loading Data

Basic MySQL Queries

INNER and OUTER JOINS

Using MySQL Text Functions

Statistics with MySQL

IF, CASE WHEN THEN

You can download the data and code .