Delete a space function in a string or field in mysql

Deletion of the space function in a string or field in mysql ltrim function mysql> select concat ('. ', ltrim ('ddd '),'. '); rtrim function www.2cto.com mysql> select concat ('. ', rtrim ('ddd '),'. '); trim string function, which is 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. UPDATE 'tran 'set'status' = '1' WHERE trim (replace ('www.2cto.com ', '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 by php development.