trim leading and trailing double quotes using mysql query

by Ramshan 2014-08-02 16:28:01

you can trim trim leading and trailing double quotes using mysql update query,
UPDATE table SET field_name = TRIM(BOTH '"' FROM table)
the above query will trim/remove double quotes from leading and trailing content of the given field...
519
like
0
dislike
0
mail
flag

You must LOGIN to add comments