Re: PHP & MySQL

'order by text asc' will sort in alphabetical order A-Z .. and your query should be select [campo] from table where campo like 'A%' ... seems like an expensive way of sorting ... i think mysql has natural order sorting functions in there somewhere ... Steve "Marisol díaz e." <mdiaz@tecnopro.net> wrote in message news:000e01c1113b$5df255f0$6a39a8c0@NTDOMAIN.local... > select [campo] from [tabla] order by [campo] > > if you want for each leter > > select [campo] from [tabla] where [campo] like 'A' > > Marisol > ----- Original Message ----- > From: "Erich Kolb" <ekolb@randbreceivables.com> > To: <php-general@lists.php.net> > Sent: Friday, July 20, 2001 11:32 AM > Subject: [PHP] PHP & MySQL > > > > When you query a MySQL Database, how do you set the order alphabetically? > > > > -- > > 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 > > >