Order By based on IF()

[Jordan Pritt]

Say you query x,y,and z from a MySQL database (obviously) and you have a few IF() blocks inside your where clause. If one wanted to change the ORDER BY based on which whether or not the query came from the true or false how would one go about doing so?

For example say if the query resolved in the IF() as being true ORDER BY is LIMIT 3 but if the IF() resolved to false ORDER BY LIMIT needs to be 2,4 not 3.

Thanks for any advice or tips!