Sorting posts by Multiple custom fields in defined order

You can use FIELD or FIND_IN_SET:

return "FIELD(mt1.meta_value, 'Head Teacher', 'Deputy', 'Teacher', 'Support', 'Clerical') ASC, mt2.meta_value ASC";

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field

Related Posts:

  1. Sorting posts by custom date fields (non standard date format)
  2. Order posts by date and then by custom field
  3. Revolution Slider Orderby Two Custom Fields
  4. Order Posts by meta value AND published date
  5. Understanding the orderby in WP_Query?
  6. Order by empty custom field
  7. meta_value_num not ordering all items
  8. Order 2 meta_queries differently in WP_Query?
  9. Order Custom Field by Price
  10. query_posts with sorting on a custom datestamp
  11. WP_Query sort by ACF date field (newest first) with blank dates first
  12. WP_Query – Order results by meta value
  13. Can wp_query return posts meta in a single request?
  14. Meta query with string starting like pattern
  15. compare meta_query in get_posts arguments
  16. Order by optional meta key?
  17. Order by DESC, ASC in custom WP_Query
  18. WP_Query order by multiple meta keys & fields
  19. Secondary Sort (fallback) for WP_Query
  20. Query Posts in a Predefined Order
  21. How to get order of posts?
  22. Get_post() with meta_key when compare is a date
  23. querying with custom meta field with meta_query
  24. Group posts by custom field
  25. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  26. Merge 2 args in one WP_Query and order it by date
  27. getting posts and number by specific meta value in multiple meta
  28. How to query using a combination of custom_field values?
  29. Order posts ascending with number in title
  30. List taxonomy terms plus their latest post ordered by post date
  31. WordPress altering my custom query, How to fix it?
  32. Order by meta_key in custom post type doesn’t affect the query
  33. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  34. wp_query with multiple custom fields
  35. Display link to taxonomy archive only if it has posts with certain custom field values
  36. WP_Query Order by Specific Post ID First
  37. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  38. Group WP_Query by meta_key date
  39. Orderby ASC changes to DESC in WP_Query
  40. Display custom field meta outside loop, site wide
  41. Extend product search with meta in WooCommerce
  42. how to make members list directory through wordpress post custom meta key.
  43. Query posts without meta preload
  44. Adding multiple meta_key fields as orderby options to a WP Query via a function
  45. Order Custom Post Type by Custom Field Value
  46. Advanced ordering of query_posts
  47. Query all posts if multiple meta key don’t exist
  48. meta_compare not comparing whole integer
  49. wp_query to print posts if have X custom field value
  50. Why is WP_Query not displaying expected data?
  51. How to Create a Random List of Child Pages
  52. WP_Query Meta_key is text value and need to sort as numeric not working
  53. filter wp_query result with custom field values
  54. Order post type by sum of two custom fields
  55. Specify strict ‘order by’ in WordPress query
  56. How to order posts on each different category?
  57. Get every post with value in meta key
  58. Using get_posts to get posts based on a checkbox value with Advanced Custom Fields
  59. Order WP_Query results by meta key value in custom query
  60. How order posts from category by date and comment count?
  61. WP_User_Query orderby meta_val_num
  62. WP_Query custom order and pagination
  63. Comparing 2 Decimal Numbers from custom fields and displaying posts
  64. WP_Query order by multiple meta keys & fields
  65. How do i create a custom post query when the meta value is an array?
  66. How to add a “base” filter for all posts visible to visitors on the site?
  67. WP Query – grouping posts by same meta key, adding together values from another key
  68. Retrieve all custom field values of a specific custom field metakey as an array, inside WP_Query
  69. meta_query is overriding default search
  70. Custom order of posts in wp_query and different taxonomies
  71. WordPress Query custom ordering by temporary variable
  72. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  73. WP_User_Query Orderby Not Working
  74. Query Order By Number Variable From API
  75. using custom meta user data to run queries in WordPress
  76. Order posts by title and custom field value?
  77. How to create URL parameters to run custom queries?
  78. Order & Orderby clause not working with custom query
  79. List users by Year of Birth using a foreach loop to dynamically populate years and data
  80. Custom WP_query and integrating into theme file
  81. Best way to Order Post in Home without a plugin
  82. Query All Attachments and Order by Parent Publish Date
  83. Using custom field as ‘orderby’ value causing post grouping by publish date
  84. Sorting posts by meta values: 2 different orders
  85. Sorting Posts with meta value not working
  86. Order by three custom fields (Y-m-d), then separate into yearly sections
  87. Order posts by custom column using pre_get_posts
  88. Add filter to Orderby Parameter using Array
  89. Loop through multiple custom fields with increasing number
  90. Order WP_Query results in order other than ASC or DESC
  91. Custom query to order by multiple taxonomies
  92. new WP_query using custom fields
  93. Sorting: custom query with orderby meta_value_num THEN by title
  94. Get post closest to today
  95. query post based on comparison
  96. orderby in WP_query doesn’t works
  97. 404 on Pages for Custom Post Type & Query_Posts
  98. Order by meta values
  99. orderby and order filter in get_posts or WP_query function in wordpress not working
  100. Get posts by meta value except one post [closed]