PHP Check If Word Exists, Then Echo Something Different

[creativeink]

Hey there,

Having trouble finding online a solution but I am...

Looking for a chunk of code that will allow me to alter text queries from my database.

Basically if my query contains the word 'Yes' I want it to say 'No' instead, Even though in the database it is stored as yes.

Any ideas ?

Thanks for your help!

[kender]

preg_replace()