How to trim all columns using mysql

Databases
1

i insert some value with blank space.how 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

2

i just tested it, it works fine for me

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

1 Like
3

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