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.