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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER