Remove whitespaces from a column in MySQL database

Posted In: blog |

To remove all leading and trailing whitespaces :

To remove only the trailing whitespaces :

The above example could be used to remove any character or characters from the begging or end of a text field. For more examples look into mysql function reference.


Post Tags: mysql |


Comments Off on Remove whitespaces from a column in MySQL database