In running the following query, I get a ton of results:

SELECT DISTINCT item, category
FROM productdata
WHERE item
ORDER BY item;


However, I'm trying to use the following Regexp:

SELECT DISTINCT item REGEXP "[a-mA-M].*", category
FROM productdata
WHERE item
ORDER BY item;

... in order to only display the Items which start with the letters A through M.

I've tried numerous different regexp formats, but no luck.
Any ideas why this wouldn't be working ?
TIA !

...because it always checks the string "item" not the column value of item

It must be used in the WHERE condition:

Doh !... lol... didn't quite see that

Thanks a bunch Roga !