15 Sept 2015

Mysql Query to Trim white space in the field of table

Mysql Query to Trim white space in the field of table

UPDATE custom_category SET category_title = TRIM( REPLACE( REPLACE( REPLACE( category_title, '\t', '' ) , '\n', '' ) , '\r', '' ) )
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)