MySQL sorting: NULL to the end & use index? Not possible?
- by Vojto
Hello fellow experts,
I have a huge table and I want simple sorting.
It could be so easy. I could just create an index and do some really fast sorting thanks to that index.
But my client wants to put NULLs to the end, which is complicates the whole situation.
Instead of simple: SORT BY name ASC I have to do SORT BY name IS NULL ASC, name ASC. That would be ok, but it because of that my index is useless, and the sorting is very slow.
I don't know if there's a way to solve this problem, but if there is one, I desperately ask for help. :'(