Delete string or field hollow function in MySQL

LTrim function

The code is as follows	Copy Code
Mysql> Select Concat ('. ', LTrim (' ddd '), '. ');

RTrim function

The code is as follows	Copy Code
Mysql> Select Concat ('. ', RTrim (' ddd '), '. ');

Trim string function, is really powerful. Not only does it eliminate the space at the end of the string, but it also eliminates any character we specify. LTrim (), RTrim () is just a subset of its features.

The code is as follows	Copy Code
UPDATE ' Tran ' SET ' status ' = ' 1 ' WHERE Trim (replace (' msg ', ' rn ', ')) = ' I love you ';

The data in the carriage return to replace the line and then trim off, to achieve the purpose, although not particularly perfect, but because there is no way to control the user input, so can only make this unwise, but the efficiency of MySQL built-in function is still very guaranteed