Return results in a specific order
I have been asked to sort page results in a particular order that is different to ASC, DESC and RAND().
So, I need to return results something similar to this:
Brakes
Oil Filters
Axels
Bushes
Carpets
etc through to Z
I need to pull out brakes followed by oil filters, then everything else a-z. Is this possible?
Thanks.