List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:July 26 1999 10:19pm
Subject:Re: question
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...
Thread
questionAnthony Allen27 Jul
  • Re: questionJohan Isacsson27 Jul
    • Re: questionNem W Schlecht27 Jul
  • Re: questionJim Faucette27 Jul