I am trying to figure out the correct syntax to do a search and replace on the
subject....

I got the find working...

SELECT *
FROM `w3t_Posts`
WHERE `B_Subject`
LIKE '[FP7] %'



Now I want the '[FP7]' to be changed to '[FM7]'

this is not going to be exact but it will look something like this

UPDATE w3t_Posts SET B_Subject = REPLACE(B_Subject, '[FP7]', '[FM7]');

This will not destroy anything else will it?

Nope

Forgot to come back and say thanx...