My regex patch should do that
SELECT * FROM Categories WHERE CategoryDescription RLIKE 'Beverages" and CategoryDescription NOT RLIKE 'Whiskey';
In such a simple string matching I suspect a regex search is totally overkill... that's ok for a db containing 1000 rows, but try it on 700,000 rows (390Mb) like the one i have here ;-)
Yup, as soon as I sent it I thought "What a perfect application for LIKE '%Whiskey%'.. And I do like Whiskey!
:p)
Brad
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]