mysql query between first letters ???
Posted: Tue Jul 24, 2007 1:40 am
hello
i need to get the result from city table ,but i need the result to get the citys that the firs leter in between:
A-E
F-J
K-O
P-T
U-Z
to get the first leter i use
$query = "SELECT * FROM uk_area WHERE name LIKE 'A_%_%'";
but i dont whant to ad AND ... AND untill E
i like to use somthing like BETWEEN
but i dont know
i did this but i got error
$query = "SELECT * FROM uk_area WHERE name BETWEEN LIKE 'A_%_%' AND LIKE 'E_%_%'";
can someone let me know what to do
THANKS
i need to get the result from city table ,but i need the result to get the citys that the firs leter in between:
A-E
F-J
K-O
P-T
U-Z
to get the first leter i use
$query = "SELECT * FROM uk_area WHERE name LIKE 'A_%_%'";
but i dont whant to ad AND ... AND untill E
i like to use somthing like BETWEEN
but i dont know
i did this but i got error
$query = "SELECT * FROM uk_area WHERE name BETWEEN LIKE 'A_%_%' AND LIKE 'E_%_%'";
can someone let me know what to do
THANKS