RE: [PHP] MySQL
| From: | Robert V. Zwink | Date: | Fri, 08 Mar 2002 15:19:39 +0000 |
| Subject: | RE: [PHP] MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-87774@lists.php.net to get a copy of this message | ||
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:rduriancik@indprop.gov.sk]
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