Detailed introduction to MySQL sorting

MySQLSort

We know that we use the SQL SELECT statement to read data from a MySQL table.

If we need to sort the read data, we can use MySQL's ORDER BY clause to set which field and method you want to sort by, and then return the search results.

Syntax

The following is a SQL SELECT statement that uses the ORDER BY clause to sort the query data before returning the data:

SELECT field1，field2，... fieldN table_name1，table_name2 ...ORDER BY field1，[field2 ...] [ASC [DESC]]

You can use any field as a sorting condition, Thereby returning the sorted query results.

You can set multiple fields to sort.

You can use the ASC or DESC keyword to set the query results to be sorted in ascending or descending order. By default, it is sorted ascending.

You can add WHERE ... LIKE clause to set conditions.

Using the ORDER BY clause in the command prompt

The following will use the ORDER BY clause in the SQL SELECT statement to read the data in the MySQL data table tutorials_tbl:

Example

Try the following example, the results will be sorted in ascending order

root @ host＃mysql -u root -p password;
输入密码：*******
mysql> use TUTORIALS;
数据库已更改
mysql> SELECT * from tutorials_tbl ORDER BY tutorial_author ASC
+ ------------- + ---------------- + ----------------- + ----------------- +
| tutorial_id | tutorial_title | tutorial_author | submission_date |
+ ------------- + ---------------- + ----------------- + ----------------- +
| 2 | 学习MySQL | Abdul S | 2007-05-24 |
| 1 | 学习PHP | 约翰·波尔 2007-05-24 |
| 3 | JAVA教程| Sanjay | 2007-05-06 |+ ------------- + ---------------- + ----------------- + ----------------- +
3行集（0.42秒）
MySQL的>

Read all the data in the tutorials_tbl table and sort it in ascending order of the tutorial_author field.

Using the ORDER BY clause in PHP scripts

You can use the mysql_query() of PHP function and the same SQL SELECT command with the ORDER BY clause to retrieve data. This function is used to execute SQL commands and then output all queried data through the PHP function mysql_fetch_array().

Example

Try the following example. The queried data is returned in descending order of the tutorial_author field.

<？PHP
$ dbhost =&#39;localhost：3036&#39;;
$ dbuser =&#39;root&#39;;
$ dbpass =&#39;rootpassword&#39;;
$ conn = mysql_connect（$ dbhost，$ dbuser，$ dbpass）;
if（！$ conn）
{
  die（&#39;无法连接：&#39;。mysql_error（））;
}
$ sql =&#39;SELECT tutorial_id，tutorial_title， 
               tutorial_author，submission_date
        FROM tutorials_tbl
        ORDER BY tutorial_author DESC&#39;;
mysql_select_db（ &#39;教程&#39;）;
$ retval = mysql_query（$ sql，$ conn）;
如果（！$ retval）
{
  die（&#39;无法获取数据：&#39;mysql_error（））;
}
while（$ row = mysql_fetch_array（$ retval，MYSQL_ASSOC））
{
    echo“教程ID：{$ row [&#39;tutorial_id&#39;]} <br>”。
         “标题：{$ row [&#39;tutorial_title&#39;]} <br>”。
         “作者：{$ row [&#39;tutorial_author&#39;]} <br>”。
         “提交日期：{$ row [&#39;submission_date&#39;]} <br>”。
         “--------------------------------结果”;
} 
echo“成功获取数据\ n”;
mysql_close（$康恩）;
？>

【Related Recommendations】

1. Special Recommendation:"php Programmer Toolbox" V0.1 Version download

2. Free mysql online video tutorial

3. Those things about database design

The above is the detailed content of Detailed introduction to MySQL sorting. For more information, please follow other related articles on the PHP Chinese website!