How to sort a row or column in mysql

method:

By desc:

Neither can be achieved:

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='Lux Forever Rejuvenating Soap 115g'
or sp.productname='Crest Green Tea Mint Toothpaste 180g'
or sp.productname='Xinwei Orchard Orchid Beans 190g/bag 1 bag of roasted beans and snacks' 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='Lux Forever Rejuvenating Soap 115g'
or sp.productname='Crest Green Tea Mint Toothpaste 180g'
or sp.productname='Xinwei Orchard Orchid Beans 190g/bag 1 bag roasted beans snacks' ORDER BY sp.productid not in(11042723)

Mysql: Put the specified data row in front

If it is just one row of data, you can do this:

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

Mainly "user_id<>7", the user with id 7 will be ranked first.

If there are multiple rows of data:

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

mysql sort a column by specifying the value first

Sort a single column first:
mysql sort 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 sort in reverse order according to category_id

Sort multiple columns first:

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

The first row of province = 10106000, the first row of city = 10106001 in province = 10106000

You may also be interested in:

How to convert a column of comma-separated values into columns in MySQL
Detailed explanation of MySQL row locks when encountering composite primary keys and multi-column indexes
Mysql method to calculate the difference between two adjacent rows of a column
MySQL column to row conversion, method of merging fields (must read)
MySQL column to row conversion and year-month grouping example
MySQL column to row conversion tips (share)
Detailed examples of converting rows to columns and columns to rows in MySQL
Implementation of dynamic conversion of mysql rows and columns (contingency table, cross table)
Database implementation of row and column conversion (mysql example)
How to convert rows to columns in MySQL

<<: Detailed explanation of the correct way to configure SSL (https certificate) in Apache on Ubuntu

>>: TimePicker in element disables part of the time (disabled to minutes)