PDA

View Full Version : REGEXP range of characters [a-d]


papas
11-15-2007, 09:15 AM
hello everyone


i want to make a query that returns all the values that start from a letter

for example

search a-d
should return all the names that start from the letter a,b,c or d and so on

i have tried so far

SELECT *
FROM tbl_stores a
WHERE a.store_name
REGEXP '[[:<:]][a-d]'

thx

shyam
11-15-2007, 09:41 AM
SELECT *
FROM tbl_stores a
WHERE a.store_name
REGEXP '^[a-d]'