CODE EXAMPLE FOR SQL

mysql select field if condition

select IF('fieldname with condition','if true value','if false value') from table_name where 1;