PHP MYSQL WHERE and with or

Would like to ask how to do next where conditions

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

The condition is "the status must have been completed and then the type must be empty"
And then any one of them has a match.

I do this and it becomes a status. Not completed type is not empty and will be searched out

Reply content:

Would like to ask how to do next where conditions

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

The condition is "the status must have been completed and then the type must be empty"
And then any one of them has a match.

I do this and it becomes a status. Not completed type is not empty and will be searched out

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

