What is the proper way to insert an if statement into a mysql query

Question

What is the property way to insert an IF statement into a mysql query?

SELECT * FROM table WHERE (column1 > 'value')

What if I wanted to put a condition within that query like:

SELECT * FROM table WHERE ((column1 > 'value')and(IF column2 = 'n' THEN WHERE column3 > '5'))

Answer 1

This should do what you want

SELECT * FROM table 
WHERE (column1 > 'value' and column2 != 'n')
    OR (column1 > 'value' and column2 = 'n' and column3 > '5')

Answer 2

how about a case statement?

Answer 3

Combine your conditions with AND and OR:

 SELECT * FROM table WHERE
     column1 > 'value' AND (column2 <> 'n' OR column3 > '5')