Can anyone tell me how I can set up the following please?

I need to set up a script that will check to see if a field in a mysql db contains one of a list of words and another field is blank.

For example, if field1 contains red, blue, green or yellow and field4 is blank say yes.

How would I set up the script to show this?

Thanks for any help in advance?