MySQL Substring to Find a Character & Return Left. MySQL includes a number of built-in string manipulation functions that are similar to the functions provided by Web scripting languages such as PHP.

SQL has several built-in functions with which you can convert integer to character data. STR() The STR() function takes a number and turns it into characters, such as the following example shows: ...