Order by FIELD in MYSQL

by

how abt this:

select a.col as type,coalesce (`COUNT`,0) as `count`
from 
(select 'A' as col union all
select 'B' as col union all
select 'C' as col union all
select 'D' as col )a
left join Table1 T
on a.col=T.type
order by FIELD(a.col,'A','B','C','D') ;

SQL fiddle demo

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. MySQL: How to allow remote connection to mysql
  6. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  7. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. Cannot connect to Database server (mysql workbench)
  10. How to connect mysql workbench to running mysql inside docker?
  11. MySQL Workbench: How to keep the connection alive
  12. How do I retrieve my MySQL username and password?
  13. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  14. MySQL error 1022 when creating table
  15. Is there a naming convention for MySQL?
  16. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  17. MySQL Errno 150
  18. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  19. error code 1292 incorrect date value mysql
  20. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  21. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  22. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  23. mySQL query to search all tables within a database for a string?
  24. Create a new database with MySQL Workbench
  25. Errno 121, duplicate key on write or update?
  26. mysql error 1364 Field doesn’t have a default values
  27. SQL: What is the default Order By of queries?
  28. Mysql string split [duplicate]
  29. Increment a database field by 1
  30. Find and replace entire MySQL database

Leave a Comment