RE: Strip off leading and trailing spaces once in db?

UPDATE my_table SET my_column = TRIM(my_column), my_other_column = TRIM(my_other_column) etc... Dave Merrill Is it possible to remove all trailing and leading spaces for selected fields once the data has already been loaded? Steve -- MySQL General Mailing List For list archives:

Strip off leading and trailing spaces once in db?

Is it possible to remove all trailing and leading spaces for selected fields once the data has already been loaded? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]