Hi.
I'm wondering if there is a better way to do this:
SELECT news.id FROM news
WHERE news.headline ~* '(japan|office)'
OR news.body ~* '(japan|office)'
ORDER BY news.posted DESC;
It is for small articles; a few hundred or so rows in the table and not
expecting millions.
Cheers,
Mark