Simulating MySQL’s ORDER BY FIELD() in Postgresql

by

Ah, gahooa was so close:

SELECT * FROM currency_codes
  ORDER BY
  CASE
    WHEN code="USD" THEN 1
    WHEN code="CAD" THEN 2
    WHEN code="AUD" THEN 3
    WHEN code="BBD" THEN 4
    WHEN code="EUR" THEN 5
    WHEN code="GBP" THEN 6
    ELSE 7
  END,name;

More Related Contents:

  1. How to filter SQL results in a has-many-through relation
  2. How to select the nth row in a SQL database table?
  3. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  4. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  5. Simple Random Samples from a Sql database
  6. SQL: Repeat a result row multiple times, and number the rows
  7. Why do results from a SQL query not come back in the order I expect?
  8. Best practices for SQL varchar column length [closed]
  9. Relationship between catalog, schema, user, and database instance
  10. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  11. What resources exist for Database performance-tuning? [closed]
  12. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  13. Are SELECT type queries the only type that can be nested?
  14. how to cast the hexadecimal to varchar(datetime)?
  15. Postgres LEFT JOIN with WHERE condition
  16. How do you write a case insensitive query for both MySQL and Postgres?
  17. Foreign key to one of many tables?
  18. Import MySQL dump to PostgreSQL database
  19. What are the max number of allowable parameters per database provider type?
  20. What happens when I exhaust a bigint generated key? How to handle it?
  21. Compare two MySQL databases [closed]
  22. Storing image in database directly or as base64 data?
  23. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  24. What does the KEY keyword mean?
  25. MySQL utf8mb4, Errors when saving Emojis
  26. How to store unicode in MySQL?
  27. Search for string within text column in MySQL
  28. Clear MySQL query cache without restarting server
  29. Mysql insert into 2 tables
  30. GRANT with database name wildcard in MySQL?

Leave a Comment