Problem is, 'black' sometimes is empty', and we need to ensure anything where black is NOT empty, and says "yes" in the field, come before the empty ones.
Help please. As if I set it like so
Code: Select all
ORDER BY black DESC, rcstock, title ASCJust tried this too, and it doesn't do anything differently:
Code: Select all
ORDER BY rcstock, title ASC, FIELD(black, 'yes', '') DESC