How about: UPDATE table SET data = REPLACE(data, " ", "")
For more information about the UPDATE query: http://www.mysql.com/doc/U/P/UPDATE.html For more information about MySQL string functions: http://www.mysql.com/doc/S/t/String_functions.html Robert Zwink http://www.zwink.net/daid.php -----Original Message----- From: Roman Duriancik [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 5:52 AM To: PHP-General Subject: [PHP] MySQL I have mysql table with 3 columns I need update all data in one rows that all data in this rows will be same but without space.How I do this ? Example before table: ID memo data 1 21 ab vbd 2 ds 1 c 23 3 .... .. after table: ID memo data 1 21 abvbd 2 ds 1c23 ... Thank you roman -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php