How could I reduce this query
Posted: Fri Apr 20, 2007 3:57 am
Code: Select all
SELECT DISTINCT product
FROM scheme.opservm
WHERE product LIKE 'A%'
OR product LIKE 'B%'
OR product LIKE 'C%'
OR product LIKE 'D%'
OR product LIKE 'E%'
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
SELECT DISTINCT product
FROM scheme.opservm
WHERE product LIKE 'A%'
OR product LIKE 'B%'
OR product LIKE 'C%'
OR product LIKE 'D%'
OR product LIKE 'E%'
Code: Select all
SELECT DISTINCT `product` FROM `scheme.opservm` WHERE LEFT(`product`,1) IN ('A','B','C','D','E');Code: Select all
SELECT DISTINCT product
FROM scheme.opservm
WHERE LEFT (product, 1) BETWEEN ('A' AND 'Z')