格式:
IF(<condition>, <value if true>, <value if false>)
例
SELECT
*
FROM
table_name t
WHERE
IF (
t.a IS NOT NULL,
t.d IN (
'value1',
'value2',
'value3',
'value4'
),
1 = 1
)
AND t.c = 'value5'
格式:
IF(<condition>, <value if true>, <value if false>)
SELECT
*
FROM
table_name t
WHERE
IF (
t.a IS NOT NULL,
t.d IN (
'value1',
'value2',
'value3',
'value4'
),
1 = 1
)
AND t.c = 'value5'