注:使用时,IF的位置要在where的后面
- 正确的用法:
SELECT * from table_name
where IF(condition = 0, xxx = 1, xxx = 2)
- 错误的用法:
SELECT * from table_name IF(condition = 0, where xxx = 1, where xxx = 2)
参考:https://dev.mysql.com/doc/refman/5.7/en/control-flow-functions.html#function_if