MySQL alphabetical order

[Anon]

Hello,

I would like to print from a database all the records that start with a letter between a and e and then f and j, etc.

The only way I can think of is:
$result = mysql_db_query("jc75513","SELECT * FROM websites WHERE name LIKE 'a%' ORDER BY category,name",$bp);

but seems a bit too long to do for each letter. Is there a faster way?

Chris

[fitzbean]

why do you wanna do all seperate queries?

[Anon]

I dont' really I would like to do one that prints fro a to e then on another page the results between f and j...

Thanks,

Chris

[slug58]

you might want to look at this page:

http://www.mysql.com/doc/P/a/Pattern_matching.html

and maybe this one:

http://www.mysql.com/doc/C/o/Comparison_Operators.html

hope this helps,
good luck!!

[slug58]

$result = mysql_db_query("jc75513","SELECT * FROM websites WHERE name REGEXP \"^[a-e]\" ORDER BY category,name",$bp);

hope this helps,
good luck!!