How to trim all columns using mysql

i insert some value with blank to remove all whitespace i’m using this query

update tablename set fieldname = trim(fieldname)

i execute this query 0 rows affected message only display.

fieldname datatype is varchar

i just tested it, it works fine for me

perhaps you could give us a test case… CREATE TABLE with INSERT statements

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.