Re: question

[Jim Faucette]

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...