Mysql deletes the space function in a string or field _ MySQL

The space function bitsCN.com in a string or field is deleted in mysql.

Ltrim functions

The code is as follows:
Mysql> select concat ('.', ltrim ('http://www.hzhuti.com/nokia/n76 '),'.');

Rtrim functions

Mysql> select concat ('.', rtrim ('ddd '),'.');

Trim string functions are really powerful. It not only removes spaces at the beginning and end of a string, but also removes any specified characters. Ltrim (), rtrim () is only a subset of its functions.

The code is as follows:
UPDATE 'Tran'
SET 'status' = '1'
WHERE trim (replace ('MSG ', 'RN', '') = 'I love you ';

When the carriage return and line breaks in the data are replaced with spaces and trim is removed, the goal is achieved. although it is not perfect, it cannot be controlled during user input, fortunately, the efficiency of MySQL built-in functions is quite guaranteed.

BitsCN.com