"Of course, the whole idea of structuring data into rows and columns is to make it easier to get a focused result set. And a great part of that focus comes from the WHERE clause (maybe you remember this from the UPDATE and DELETE statements you learnt last time) to the SELECT statement, which allows you to define specific criteria for the result set. Records that do not meet the specified criteria will not appear in the result set."

"... If you'd like to see the data from your table ordered by a specific field, SQL offers the ORDER BY construct. This construct allows you to specify both the column name and the direction in which you would like to see data (ascending or descending)."

Complete Story

Related Stories:
MySQL 3.23 is now finally released as a production release(Jan 19, 2001)
PR: NuSphere Releases Version 1.13.5 of NuSphere MySQL(Jan 16, 2001)
LinuxJournal: Installing and Configuring Apache, PHP and MySQL(Jan 16, 2001)
Patch for Oracle introduces a new configuration parameter in mod_plsql(Jan 12, 2001)
PHP Tutorial: Using ADODB to port your MySQL code (Dec 17, 2000)
Connecting to MySQL with PHP(Dec 02, 2000)