Delete string or field hollow function in MySQL

The Ltrim,rtrim function is provided in MySQL to remove the first Mao of the character so if I want to delete the word Furu "ABC Fdsa" How To do it, let's look at the tutorial

LTrim function

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

RTrim function

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

The trim string function is really powerful. It not only eliminates the space at the end of the string, but also eliminates any character we specify. LTrim (), RTrim () is just a subset of its functionality.

The code is as follows
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