Databases: searching for a word in entries containing multiple words using 'like'

Hi,

raw SQL for you to evaluate.. 

Code:

SELECT * FROM test
WHERE LOWER(words) LIKE '% art%' OR LOWER(words) LIKE 'art%'

That looks like it might do the job! Pretty simple and pretty obvious really. I really need to brush up on my SQL as well as regex.

I’m not at the office at the mo, so I’ll check it out after the weekend and report back.

Many thanks!