Re: Selecting first letter from MySQL entry

I guess select * from clients_tb where firstname like '$letter%' it could help On Wed, 9 Aug 2000, Tyler Longren wrote: tyler.: Hello everyone, tyler.: tyler.: I need to be able to select the first letter in a MySQL field. the field tyler.: name is first (for first name). There are peoples names listed there. I tyler.: have links set up to look like this: tyler.: index.php?letter=A tyler.: index.php?letter=B tyler.: index.php?letter=C tyler.: and so on tyler.: So when a user clicks on index.php?letter=C it would need to display all of tyler.: the first names that begin with C. tyler.: tyler.: How do I accomplish this? tyler.: tyler.: Regards, tyler.: -- ---------------------------------- Yurais Fernández Leal MediRed Network SysAdmin. yurais@medired.scu.sld.cu http://www.scu.sld.cu/ ICQ: 33792610 ICQ-GW: 1031 Phone: (53) 226-54204 ------------