想請問一下該怎麼下where條件
where `status` = '已完成' and `type` = ''and `phone` like '%{$user}%'or `phone2` like '%{$user}%'or `address` like '%{$user}%'or `name` like '%{$user}%'or `email` like '%{$user}%'order by `buytime` desc

條件是status一定要是已完成 然後type一定要是空
然後其他任一個有符合的都可以
我這樣子做會變成status不是已完成 type不是空的也會被搜索出來
回复内容： 想請問一下該怎麼下where條件
where `status` = '已完成' and `type` = ''and `phone` like '%{$user}%'or `phone2` like '%{$user}%'or `address` like '%{$user}%'or `name` like '%{$user}%'or `email` like '%{$user}%'order by `buytime` desc

條件是status一定要是已完成 然後type一定要是空
然後其他任一個有符合的都可以
我這樣子做會變成status不是已完成 type不是空的也會被搜索出來
where `status` = '已完成' and `type` = ''and ( `phone` like '%{$user}%'or`phone2` like '%{$user}%'or `address` like '%{$user}%'or `name` like '%{$user}%'or `email` like '%{$user}%')order by `buytime` desc