MySQL ORDER BY

Sort by mysql

SELECT * FROM table_name ORDER BY col1 ASC;				-- ASCending is default
SELECT * FROM table_name ORDER BY col1 DESC;			-- DESCending
SELECT * FROM table_name ORDER BY col1 DESC, col2;		-- col1 DESC then col2 ASC

Ascending order mysql

  
 SELECT 
   column_name1, column_name2, column_name3
FROM 
   table_name
ORDER BY 
   column_name1 [ASC|DESC], 
   column_name2 [ASC|DESC],
   ...;

Source: mysqltutorial.org

MySQL ORDER BY

SELECT 
   select_list
FROM 
   table_name
ORDER BY 
   column1 [ASC|DESC], 
   column2 [ASC|DESC],
   ...;

Source: mysqltutorial.org

Order by value mysql

SELECT * FROM mytable WHERE id IN (1,2,3,4) ORDER BY FIELD(id,3,2,1,4);

# or
SELECT * FROM mytable ORDER BY FIELD(field_name,'value1','vaue2','etc');

Source: dba.stackexchange.com

MYSQL ORDER BY

SELECT * FROM adminra_RepAda.customerServiceRequests order by insertDate DESC;

Mysql order by list

ORDER BY FIELD(id, 3, 11, 7, 1)

Source: stackoverflow.com

Similar codes

0 vote139 views1 answer
Postgresql get current user name
SQL
0 vote148 views1 answer
Sql trying to delete database in use
SQL
0 vote135 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote156 views1 answer
Soql queries for not contact related account records in salesforce
SQL
2 votes150 views1 answer
How to make insert script from table in SQL server
SQL
11 votes151 views1 answer
Mysql text type max length
SQL
2 votes110 views1 answer
Foreign key example in dbms
SQL
2 votes170 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote148 views1 answer
How to order result of subquery in select
SQL
1 vote147 views1 answer
Adding a default constraint to an existing column in sql
SQL