At 16:17 -0800 2/6/02, Richard Reina wrote: >I am trying to trim both leading and trailing whitespace from a TEXT >column in my SELECT query. I found the TRIM() command in the >manual, however, I can't get it to act upon a column name instead of >an actual string. Can anyone help?
If you just say TRIM(col_name) it will return the trimmed column value, but it won't change the column itself. Try updating the column to its trimmed value: UPDATE tbl_name SET col_name = TRIM(col_name); > >Thanks, > >Richard --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
