为什么Mysql返回错误的行数

Why Mysql is returning wrong count of rows?

本文关键字：错误 Mysql 返回为什么 | 更新日期: 2023-09-27

我在数据库中有两个与名称和地址匹配的信息。这段代码不是返回2，而是返回21。请参见下文;(表)雇员id名字地址

$select = mysql_query("
SELECT * 
  FROM employees 
 WHERE name LIKE '%John%' 
    OR name LIKE '%Johanson%' 
   AND address='Streetford End'
   ");
$count = mysql_num_rows($select);
echo $count

SELECT * FROM employees WHERE (name LIKE '%John%' OR name LIKE '%Johanson%')
  AND address='Streetford End'