mysql select column if condition code example

Example: mysql select field if condition

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