Re: Selecting first letter from MySQL entry

I don't know MySQL exactly, but you have to make an SQL-Statement "Select * from MyTable where first like A%" or "..like B%" and so on. Regards Martin Tyler Longren wrote: > Hello everyone, > > I need to be able to select the first letter in a MySQL field. the field > name is first (for first name). There are peoples names listed there. I > have links set up to look like this: > index.php?letter=A > index.php?letter=B > index.php?letter=C > and so on > So when a user clicks on index.php?letter=C it would need to display all of > the first names that begin with C. > > How do I accomplish this? > > Regards, > -- > Tyler Longren > [Web Development] > Premier Visual Services > http://www.pvs2000.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net