Remove white space in a mysql field in a single query

by Subramanian 2014-03-12 18:23:58

Remove white space in a mysql field in a single query :

Query :
update table_name set field = TRIM(field);
981
like
0
dislike
0
mail
flag

You must LOGIN to add comments