[SOLVED] mysql searching

[yjim]

how can i issue a mysql search where the first letter of my item is A or B etc.. or if it starts with a number?

[Aravinthan]

Wrong forums...

 

But you can use LIKE command

[yjim]

ok i have this code

 

SELECT * FROM media_cat WHERE name LIKE '(0-9)%' ORDER BY name ASC

 

its not working. im trying to get all the results that start with a number value.

[Aravinthan]

Try:

SELECT * FROM media_cat WHERE name LIKE [0-9]%' ORDER BY name ASC

 

Should work...

[sdi126]

SELECT * FROM media_cat WHERE substring(name,1,1) in(0,1,2,3,4,5,6,7,8,9)  ORDER BY name ASC

[Aravinthan]

I made a typo,

 

It should be:

SELECT * FROM media_cat WHERE name LIKE '[0-9]%' ORDER BY name ASC

[yjim]

neither works..i have several items that start with integers 0-9 also.

[Aravinthan]

Are you sure?

 

I tried it and it works fine for me...

 

What is the error you get?

[yjim]

empty results

[Aravinthan]

Run this:

SELECT * FROM media_cat WHERE name LIKE '0%' ORDER BY name ASC

And tell me if gives a result

[yjim]

that works for the rows that start with 0 digits, but i also have rows that start with other numbers that arent being displayed.

[yjim]

fixed, thanks.

 

mysql_query("SELECT * FROM `media_cat` WHERE substring(name,1,1) RLIKE '[0-9]'");