Database Again

[Anon]

Now I want to change XXX to ABC
How to do that ?

TABLE NAME = MY_TEXT with data :

================================

|ID | MY_TEXT | DATE |

|1 | Hei this is XXX | 21 |

|2 | XXX is me dude | 21 |

|3 | I dont know XXX | 21 |

|4 | What XXX is good | 21 |

I try this one but it\'s not working
UPDATE your_table_name SET my_text = \'ABC\' WHERE my_text = \'XXX\'

[amcgrath]

where my_text lik '%XXX%'... you'd be dangerous if you read the manual...

[Anon]

the XXX is just an example not the real data

[amcgrath]

I know that.