[nycphp-talk] Global SQL Update Query Needed
Peter Sawczynec
ps at pswebcode.com
Wed Jul 6 16:04:58 EDT 2005
I need a SQL query for MySQL 4.1.
The table has over 20,000 rows. Each row has a "keywords" field. The
keywords field has either zero words, one word or a series of colon (:)
delimited words.
Need to swap all occurrences of the keyword "moon" with new keyword "lunar".
What SQL query might do that.
Warmest regards,
Peter Sawczynec
Technology Director
PSWebcode
ps at pswebcode.com
718.543.3240
More information about the talk
mailing list