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
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