forum_id
und post_id
in der Tabelle phpbb_posts
enthalten ist.Einfach mit "and" verknüpfen:
Code: Alles auswählen
UPDATE phpbb_posts
SET post_text = REPLACE(post_text, 'old text', 'new text')
WHERE post_text LIKE '%old text%'
AND forum_id = 123
AND post_id = 456