mysql search syntax

[dodozhang21]

hi does anyone know how to make a mysql syntax that would return all entries begin with A - G
for example, i tried

SELECT * FROM CollegeBirdHouses WHERE ItemCategory LIKE 'A%' OR 'B%' OR 'C%' OR 'D%' OR 'E%' OR 'F%' OR 'G%'

but it only returns the ones begin with A. but i want it to return ones with A - G.. all of them but with one query.. is that possible?

thanks!!

[bnownlater]

Did you try putting WHERE ItemCategory Like \'A%\' OR ItemCategory Like \'B%\'OR ItemCategory Like \'C%\' OR....

[veron]

SELECT * FROM CollegeBirdHouses WHERE ItemCategory LIKE 'A%' OR ItemCategory LIKE 'B%' OR ItemCategory LIKE 'C%' OR ItemCategory LIKE 'D%' OR ItemCategory LIKE 'E%' OR ItemCategory LIKE 'F%' OR ItemCategory LIKE 'G%'

[dodozhang21]

thanks!

[Anon]

SELECT * FROM CollegeBirdHouses
WHERE ItemCategory REGEXP BINARY "^[A-G]"