I've got a problem that I'm hoping someone can help with. I need to do
a query against a text column in order to extract entries that will
match whole words only - for example, a search for "cat" should match
The cat sat on the mat
It was a large cat.
Cat food is interesting.
Dog. Cat. Fish.
but not match
in a catatonic state
it was a catastrophe
It looks as if the MySQL REGEXP function is what I need here, but I
can't work out from the documentation how to get what I want.