Conditional column for query based on other columns in MySQL
select User_id,case when (YEAR(DOB) < 1980 AND Job_Title = "manager") then 'Old Fart' when (YEAR(DOB) < 1980 AND Job_Title = "associate") then 'Old Timer' when (YEAR(DOB) > 1980 AND Job_Title = "manager") then 'Eager Beaver' when (YEAR(DOB) > 1980 AND Job_Title = "associate") then 'Slacker' else 'nobody'endas Real_Title from users
If I understand correctly, I think you're looking for the CASE statement:
SELECT User_id, (CASE WHEN YEAR(DOB) < 1980 AND Job_Title = "manager" THEN "Old Fart" WHEN YEAR(DOB) < 1980 AND Job_Title = "associate" THEN "Old Timer" ... ELSE "Unknown Title" END) AS Real_TitleFROM users;