chown
to make it consistent may fix the problem.Code: Select all
UPDATE phpbb_posts SET post_text = REPLACE(post_text,'THE','THEM') WHERE post_text LIKE '%THE%;
Code: Select all
SELECT post_id, topic_id, post_text, REPLACE(post_text,'THE','THEM') WHERE post_text LIKE '%THE%;