Select #s

[JimJx]

Hi all,

I have what I hope is an easy question, but I could not find the answer anywhere in the docs....

I have a select statement:
SELECT name, address, city, phone
FROM valley
WHERE name LIKE '$search%'
ORDER BY name LIMIT %d,%d

Some of the entries in the name field in the DB begin with numbers, such as 1st Choice, 250 Central, etc.

What value do I need to search for to get these entries?

Thanks for reading!
Jim

 

[audiopro]

What do you need to find. all numbers or specific ones?

How about where substr(FEELD,1,1)>0



Keith

http://www.studiosoft.co.uk

 

[JimJx]

All numbers at the beginning of the field.

For example one can be 1st choice, another can be 250 Central, etc.....

 

[r937]

WHERE name REGEXP '^[0-9]'

r937.com | rudy.ca