Link to home
Start Free TrialLog in
Avatar of jmoriarty
jmoriarty

asked on

MySQL query to exclude numeric results?

Evening folks!

I have an interesting question. Is it possible to exclude results of a given type from a MySQL Query?

For example, if I wanted to find all locations for products that did NOT have a number in their name.

I.E.
(assume a simple table with just the 2 fields mentioned below, both varchar(20) )

SKU                LOCATION
---------------------------------
SKU1                SOD (included in the query output)
SKU2                34A (not included in the query output)
SKU3                ABC (included in the query output)
SKU4                CLO (included in the query output)
SKU5                CLO34A (not included in the query output)


Thanks!
ASKER CERTIFIED SOLUTION
Avatar of nick_bal
nick_bal
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jmoriarty
jmoriarty

ASKER

Perfect! Thanks!