Trimming all fields in MySQL database

UPDATE `table1` SET `tbl_column1`= trim(`tbl_column1`);

The above SQL query  will trim all the fields in the tbl_column1


Comments

Popular posts from this blog

phpbb3 Forum not showing after creating