MySQL alphabetical listing

From: Date: Tue, 18 Sep 2001 21:37:49 +0000
Subject: MySQL alphabetical listing
Groups: php.db 
Request: Send a blank email to php-db+get-12555@lists.php.net to get a copy of this message
Heya all... I have a listing of last names in a table. I would like to get MySQL to give me a result set of last names that began with a letter so that in PHP I can put them into alpha order. I don't want a set of all names, just those with one letter (the idea being I can then have one letter per page), and I don't want to "select all" from the whole table. Does anyone know how to do this, or am I going about it the wrong way? Thanks --Photocon Conrad Hunziker III www.nightskyent.com

« previous php.db (#12555) next »