请问怎么写才能实现以下sql语句呢
SELECT * FROM table
WHERE is_delete = 0
AND member_id = 175
AND (
( name LIKE '%工%' OR birthday LIKE '%工%' )
OR ( vision IN ('') OR work_experience IN ('') )
OR ( trade IN ('2','72') OR trade_post IN ('2','72')
) ;
最佳答案
请问怎么写才能实现以下sql语句呢
SELECT * FROM table
WHERE is_delete = 0
AND member_id = 175
AND (
( name LIKE '%工%' OR birthday LIKE '%工%' )
OR ( vision IN ('') OR work_experience IN ('') )
OR ( trade IN ('2','72') OR trade_post IN ('2','72')
) ;