given that activity is a c(100) field in a table

what is the bst way to find records where severeal words are present but not necessarily together

eg:

mouse+trap+living room
i want to find all occurances where 'mouse' is existing as well 'trap' and 'living room'
at the moment i have something like
'mouse'$activity and 'trap'$ activity and 'living room'$activity

which is kind of cumbersome once there are more than 3 phrases
I hope there is a way to do that with regex???


Thnaks


Peter