您不能只使用单独的WHERE子句,例如:
SELECT * FROM tblClients
WHERE (name LIKE '%john%')
OR (surname LIKE '%john%')
检查是否在mySQL的多个列之一中找到字符串
您不能只使用单独的WHERE子句,例如:
SELECT * FROM tblClients
WHERE (name LIKE '%john%')
OR (surname LIKE '%john%')