Change all value in table

[Anon]

I want to change all the text XXX to YYY in the posts_text table.

---

ID | POST |

1 | Happy XXX |
2 | Super XXX |

3 | Mouse XXX |

I know i can do that in the phpMyAdmin by running a queries.

Can someone let me know what should i write ?

[[deleted]]

read the SQL manual about the UPDATE query syntax, and about the string function REPLACE() (note: replace, and not 'replace into'