[SOLVED] retrieve data where field starts with certain letters...

[glennn.php]

hi all -

 

having this: mysql_query("SELECT * FROM menu ORDER BY cat ASC"),

 

i'm trying to retrieve records where 'cat' starts with anything from A to M.

 

can anyone help a chap out?

 

Thanks much,

GN

[beebum]

mysql_query("SELECT * FROM menu WHERE SUBSTRING(cat,1,1) between 'a' and 'm' ORDER BY cat ASC")

[glennn.php]

awesome, thanks

 

i found another tute that did

 

...REGEXP 'A%-M%' order by cat ASC... which worked as well;

 

is there a reaon one is better than the other? PHP version, mysql version, etc...?

 

Thanks for your help.

 

GN

[PFMaBiSmAd]

Both beebum's and the query you posted are using mysql functions.

[beebum]

I suspect that the regex would be faster. Just run each one from the command line to see.

[glennn.php]

thanks both of you!!!