I am trying to join two if statements together in an SQL query, but I don't seem to be having much luck.
The two statements are:
if(c.population > 100000000, Concat("Large ", c.GovernmentForm), c.GovernmentForm)
if(YEAR(now())-c.IndepYear > 50, Concat("Modern ", c.GovernmentForm, c.GovernmentForm)
Both of these IF statements work separately of each other, but I need them to be combined into one (e.g. the output to be "Modern Large" & GovernmentForm, in a separate column on the output). I could do it as a function, or procedure, but they seem to be blocked on the MySQL we are using.