Can you add an if statement in ORDER BY?

by

Well, you can use the IF function in MySQL (Note the emphasis on function since there’s also an unrelated IF statement)…:

ORDER BY IF(TYPE='Member', LNAME, GROUPNAME) ASC

However, in this case it seems the better choice (From a flexibility standpoint) would be the CASE statement:

ORDER BY 
    CASE `type` 
        WHEN 'Member' THEN LNAME 
        WHEN 'Group' THEN GROUPNAME
        ELSE 1 END 
    ASC

Note that the entire block from CASE to END is to be considered as a single “unit”. The result of which is what you’re trying to sort against (Hence why the ASC comes after the block, rather than inside of it)…

More Related Contents:

  1. multiple auto increment in mysql
  2. How to sort MYSQL fulltext search results by relevancy
  3. Comma separated numeric values – PHP CodeIgniter
  4. PHP PDO and Mysql [closed]
  5. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  6. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  7. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  10. How to loop through a mysql result set
  11. Cannot connect to MySQL 4.1+ using old authentication
  12. Doctrine 2 and Many-to-many link table with an extra field
  13. Post form and update multiple rows with mysql
  14. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  15. Easy way to export a SQL table without access to the server or phpMyADMIN
  16. using nulls in a mysqli prepared statement
  17. How can I count the numbers of rows that a MySQL query returned?
  18. How to run the PHP script at scheduled time
  19. How to handle error for duplicate entries?
  20. How to handle PDO exceptions [duplicate]
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. mysql_insert_id() returns 0
  23. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  24. How do I get database column names in Laravel?
  25. PDO and MySQL Fulltext searches
  26. Eloquent many-to-many-to-many – how to load distant relation easily
  27. How to avoid “Using temporary” in many-to-many queries?
  28. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  29. Update query PHP MySQL [duplicate]
  30. Do I have to use mysql_real_escape_string if I bind parameters?

Leave a Comment