Unknown column 'category' in 'order clause':select *, concat( city, ', ', state ) as location, ID as id from jobs where 1 and concat( city, ', ', state ) like '%CA%' order by category