Hi!

I have a small problem selecting record-sets containing a specified word using MySQL. What I want to do is search for the word "abc" for example and have MySQL return the record-set only if "abc" was found as whole word and not as part of another word such as "abcdef", "xyzabc" or "xyzabcdef". The problem is that I cannot use " abc " in the "SELECT ... LIKE" query since "abc" might be at the beginning of a sentence or might have a comma after it ("abc def" or "abc,def"). Any idea how to solve this problem?

By the way, the table does not support full-text search.

Regards,
Sebastian