Home  >  Article  >  Database  >  Analysis of how to specify the sorting of a certain row or column in mysql (picture)

Analysis of how to specify the sorting of a certain row or column in mysql (picture)

黄舟
黄舟Original
2017-05-21 09:17:031577browse

This article mainly introduces mysqlSpecify the sorting of a certain row or column. Friends who need it can refer to the

method:

Cannot be achieved through desc:

:

Method 1:

select sp.productid,sp.productname,ss.sku from sp_product sp inner join sku_skus ss on sp.productid=ss.productid 
where sp.productname='力士恒久嫩肤娇肤香皂115g'
or sp.productname='佳洁士(Crest) 绿茶薄荷牙膏180克'
or sp.productname='心味果园 兰花豆 190g/袋 1袋 炒货豆制品休闲零食' order by (
case when sp.productid=11042723 then 1 ELSE 2 END)

Method 2:

Core sql

select sp.productid,sp.productname,ss.sku from sp_product sp inner join sku_skus ss on sp.productid=ss.productid 
where sp.productname='力士恒久嫩肤娇肤香皂115g'
or sp.productname='佳洁士(Crest) 绿茶薄荷牙膏180克'
or sp.productname='心味果园 兰花豆 190g/袋 1袋 炒货豆制品休闲零食' ORDER BY sp.productid not in(11042723)

Mysql: Put the specified data row in front

If there is only one data row, it can be like this:

SELECT * FROM user ORDER BY user_id<>7,score DESC;

Mainly "user_ida8093152e673feb7aba1828c435320947", the user id of 7 will be ranked first.

If there are multiple data rows:

SELECT * FROM user ORDER BY user_id NOT IN(7,8,9),score DESC;

mysql Sort the specified value of a certain column first

Sort a single column first:
mysql Sort the specified value of a certain column first Sorting order by case

SELECT * FROM `jcxsw`.`t_company_product` order by (
case when id=263 then 1 ELSE 4 END),category_id desc;

This sql code will first sort the data with id =263 and then look back according to category_id

Multiple columns are sorted first:

SELECT * FROM `web_membersfastsort_women` m order by 
m.province<>&#39;10106000&#39; , m.city<>&#39;10106001&#39; ,m.city desc,m.province 
desc,m.s_cid asc, m.images_ischeck desc,m.pic_num desc limit 2000,30

province = 10106000 is in the front row, in province = 10106000 city=10106001 is in the front row

The above is the detailed content of Analysis of how to specify the sorting of a certain row or column in mysql (picture). For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn