How to query data which begin with A to C

[Stalker]

DATA:ADAM,BOB,CAT,DED
RESULT:ADAM,BOB,CAT
thanks in advance.

 

[WannaFly]

no idea if its the same in mysql, but where field1 like '[A-C]%' would work in MSSQL

 

[statik213]

if MSSQL has regular expressions look into it, but here's an easy way that should work on practically any SQL server:

SELECT *
FROM table
WHERE somefield LIKE 'A%' OR somefield LIKE 'B%' OR somefield LIKE 'C%';

 

[EagleKeeper]

Or

SELECT *
FROM table
WHERE somefield >= 'A%' and somefield < 'D';