Tsab ntawv teev npe
MySQLMulti-field conditional sorting?MySQL kev txiav txim los ntawm kev nqis tes ua nqe lus nug / ua haujlwm
MySQL kev
Peb paub siv SQL SELECT nqe lus los nyeem cov ntaub ntawv los ntawm MySQL cov lus.
Yog tias peb xav txheeb cov ntaub ntawv nyeem, peb tuaj yeem siv MySQL's TXIM LOS SIS clause los teeb tsa qhov chaw koj xav txheeb los ntawm txoj kev twg, thiab tom qab ntawd rov qab cov txiaj ntsig tshawb nrhiav.
qauv sau ntawv
Cov hauv qab no yog SQL SELECT nqe lus uas siv ORDER BY clause los txheeb cov lus nug cov ntaub ntawv ua ntej xa cov ntaub ntawv rov qab:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- Koj tuaj yeem siv txhua qhov chaw raws li kev txheeb xyuas kom rov qab txheeb xyuas cov txiaj ntsig.
- Koj tuaj yeem teem ntau qhov chaw los txheeb.
- Koj tuaj yeem siv ASC lossis DESC lo lus tseem ceeb los teeb tsa cov lus nug kom raug txheeb raws li nce lossis nqis nqis.Los ntawm lub neej ntawd, nws yog nyob rau hauv ascending kev txiav txim.
- Koj tuaj yeem ntxiv qhov twg ... LIKE clauses los teeb tsa cov xwm txheej.
Siv ORDER BY clause hauv cov lus txib
Cov hauv qab no yuav siv ORDER BY clause hauv SQL SELECT nqe lus los nyeem cov ntaub ntawv hauv MySQL cov ntaub ntawv rooj chenweiliang_tbl:
piv txwv
Sim cov piv txwv hauv qab no thiab cov txiaj ntsig yuav raug txheeb nyob rau hauv ascending thiab descending order.
SQL tsi
mysql> use chenweiliang; Database changed mysql> SELECT * from chenweiliang_tbl ORDER BY submission_date ASC; +-----------+---------------+---------------+-----------------+ | chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date | +-----------+---------------+---------------+-----------------+ | 3 | 学习 Java | chenweiliang.com | 2015-05-01 | | 4 | 学习 Python | chenweiliang.com | 2016-03-06 | | 1 | 学习 PHP | 陈沩亮博客 | 2017-04-12 | | 2 | 学习 MySQL | 陈沩亮博客 | 2017-04-12 | +-----------+---------------+---------------+-----------------+ 4 rows in set (0.01 sec) mysql> SELECT * from chenweiliang_tbl ORDER BY submission_date DESC; +-----------+---------------+---------------+-----------------+ | chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date | +-----------+---------------+---------------+-----------------+ | 1 | 学习 PHP | 陈沩亮博客 | 2017-04-12 | | 2 | 学习 MySQL | 陈沩亮博客 | 2017-04-12 | | 4 | 学习 Python | chenweiliang.com | 2016-03-06 | | 3 | 学习 Java | chenweiliang.com | 2015-05-01 | +-----------+---------------+---------------+-----------------+ 4 rows in set (0.01 sec)
Nyeem tag nrho cov ntaub ntawv nyob rau hauv chenweiliang_tbl lub rooj thiab txheeb nyob rau hauv ascending kev txiav txim los ntawm submission_date teb.
Siv ORDER BY clause hauv PHP tsab ntawv
Koj tuaj yeem siv PHP muaj nuj nqi mysqli_query() thiab tib SQL SELECT hais kom ua nrog ORDER BY clause kom tau txais cov ntaub ntawv.
Cov haujlwm no yog siv los ua SQL cov lus txib thiab tom qab ntawd tso tawm tag nrho cov ntaub ntawv nug los ntawm PHP ua haujlwm mysqli_fetch_array().
piv txwv
Sim ua piv txwv hauv qab no, cov ntaub ntawv queried rov qab los ntawm qhov kev txiav txim ntawm submission_date teb.
MySQL ORDER BY test:
<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT chenweiliang_id, chenweiliang_title,
chenweiliang_author, submission_date
FROM chenweiliang_tbl
ORDER BY submission_date ASC';
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 MySQL ORDER BY 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
{
echo "<tr><td> {$row['chenweiliang_id']}</td> ".
"<td>{$row['chenweiliang_title']} </td> ".
"<td>{$row['chenweiliang_author']} </td> ".
"<td>{$row['submission_date']} </td> ".
"</tr>";
}
echo '</table>';
mysqli_close($conn);
?>Cia siab Chen Weiliang Blog ( https://www.chenweiliang.com/ ) qhia "MySQL multi-field conditional sorting? MySQL order by descending and ascending query statement/function", uas yog pab tau rau koj.
Zoo siab txais tos los qhia qhov txuas ntawm kab lus no:https://www.chenweiliang.com/cwl-476.html
Zoo siab txais tos rau Telegram channel ntawm Chen Weiliang blog kom tau txais qhov hloov tshiab tshiab!
📚 Daim ntawv qhia no muaj nuj nqis loj, 🌟Qhov no yog lub sijhawm tsis tshua muaj, tsis txhob nco nws! ⏰⌛💨
Share thiab like yog tias koj nyiam!
Koj qhov kev sib koom thiab kev nyiam yog peb qhov kev txhawb nqa tas mus li!