mysql - Mysql 多重搜索条件

Question

我有一个通过电子邮件查找用户客户端的搜索查询。我希望它也能查找名字和姓氏。

$list = mysql_query("SELECT    id, 
           user_email, 
           meta_lastname.meta_value lastname,  
           meta_firstname.meta_value firstname 
 FROM      wp_users 
 LEFT JOIN wp_usermeta meta_lastname 
 ON        meta_lastname.user_id = wp_users.id 
 LEFT JOIN wp_usermeta meta_firstname 
 ON        meta_firstname.user_id = wp_users.id 
 WHERE     meta_lastname.meta_key = 'last_name' 
 AND       meta_firstname.meta_key = 'first_name'
    AND user_email LIKE '%$searchpattern%' 
    ORDER BY lastname;");

我尝试将倒数第二行更改为

AND user_email, lastname, firstname LIKE '%$searchpattern%' 
        ORDER BY lastname;");

但这并没有奏效。

有什么想法吗？

太棒了

Answer 1

也许你只是想说

AND 
(
  user_email LIKE '%$searchpattern%' 
  OR lastname LIKE '%$searchpattern%'
  OR firstname   LIKE '%$searchpattern%'
)