How to remove white space in mysql

Remove space from date in mysql
We can update value with TRIM to remove white space from starting and ending from any character
// Update table

UPDATE table set FIELD = TRIM(FIELD);

OR
IN select query

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*
Website