mysql search number in table

Question

hi,

i am using php/mysql.

i have a product table . in which most product have starting name with number.

i want to listout all products start with any number.

any one have idea about it....

Answer 1

Ref this

SELECT * FROM product WHERE name REGEXP '^[0-9]'

Answer 2

Hello, from what i understant, your product names are something like '123myproduct'. you should be able to search the table with

select * from product where name like '123%';

The LIKE construct uses '%' as a wildcard that means 'anything'

I hope this will help you

Jerome Wagner