|List:||General Discussion||« Previous MessageNext Message »|
|From:||Jim Faucette||Date:||July 26 1999 10:19pm|
|View as plain text|
Allen, Anthony wrote: > > How do I replace the following string in a text column in MySQL? > > Ex. I want the string in column1 to be changed from > "I would like to NULL change this column" to > "I would like to ? change this column" > > In other words I am trying to replace all occurrences of the string "NULL" > with a "?". > UPDATE tablename SET column=REPLACE(column, ' NULL ', '?'); jim...
|• question||Anthony Allen||27 Jul|
|• Re: question||Johan Isacsson||27 Jul|
|• Re: question||Nem W Schlecht||27 Jul|
|• Re: question||Jim Faucette||27 Jul|