Query tables using A B C D ... links 1

[casabella]

I have successfully written a data grid table in PHP where I allow user to view 50 rows per page. I show links like one normally sees Prev 1 2 3 4 5 6 ... Next to jump from page to page.

I want to use A B C D E F ... to allow user to go directly to a group of records where KEY starts with chosen link letter.

I can write the PHP code I just do not know the mySQL query to search for KEY that starts with 'A' or 'B' or 'C' ...

Using LIKE comes to mind but I am filled with doubts about it and so I figure I ask for your assistance.

Regards,


Jose

 

[guelphdad]

WHERE LEFT(yourcolumname,1) = 'F'

also

WHERE yourcolumname LIKE 'F%'

 

[casabella]

guelphdad,

Thank you for such prompt response.


Jose