My query: ORDER BY binary FIELD(`oflags`,'N','a','A','C','o','O','h'), `usermodes`, `nick` My question: I want to order oflags that it will sort like N first, then lowercase a, followed by A next up is C then its up to lowercase o and then uppercase O and last lowercase h