Change entire database - help me

[Anon]

I need to change IP number in my database table.

What should I do
I want to replace all 10.10.0.1 in the table to 10.10.0.8

what syntax should I use to do that

[mithril]

UPDATE your_table_name SET ip = '10.10.0.8' WHERE ip = '10.10.0.1'

[Anon]

how if the 10.10.0.1 is in the table inside the text field is it working ?

[Anon]

It's not working because the IP number is a part of the table database

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 |

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

[[deleted]]

use an update query with the string REPLACE function:

http://www.mysql.com/doc/S/t/String_functions.html

[Anon]

It's still not working I dont know how to use REPLACE function for entire TABLE

[[deleted]]

did you read the manual page about the replace command?