Date: 04/11/06 (MySQL Communtiy)    Keywords: no keywords

hey folks, i have this query

SELECT entries.*, article.*, theme.entrybit
FROM ej_entry entries
LEFT JOIN ej_article article ON (article.articleid = entries.articleid)
LEFT JOIN ej_theme theme ON (theme.themeid = article.themeid)
WHERE article.userid = 10
ORDER BY entries.entry_date DESC

however i want to truncate the data returned, i have a column in the entries table in which i have strings stored such as "test,life,romance,work" as well as keeping it simple and having "test", i'm looking for a function in which i can use to just return entries with 'test' in the string, can anyone tell me what function i'm looking for?

Source: http://community.livejournal.com/mysql/92823.html