Delete a space function in a string or field in mysql _ MySQL

Delete bitsCN.com from string or space function in mysql
Deletion of the space function in a string or field in mysql ltrim function mysql> select concat ('. ', ltrim ('ddd '),'. '); rtrim functions 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 ('', '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. The author developed bitsCN.com in php.