我有两个表的用户和用户组。
我正在运行以下查询:
SELECT `u`.`id`, `u`.`fname`, `u`.`lname`, `u`.`customer_id`, `u`.`email`, `u`.`partner_id`, `u`.`campaign_promocode`, `u`.`utm_medium`, `u`.`referrral_source`, `u`.`is_active`, `u`.`created_at`, `ug`.`group_id`
FROM (`users` as u)
JOIN `users_groups` as ug ON `ug`.`user_id` = `u`.`id`
WHERE `ug`.`group_id` = '99'
OR `ug`.`group_id` = '100'
AND `u`.`is_active` IN ('1', '2')
AND `u`.`fname` LIKE '%sandeep%'
ORDER BY `u`.`id` desc
LIMIT 10
但是如果我在where子句中删除,上面的查询将返回错误的结果ug
。group_id
='99'OR ug
。group_id
='100',那么我说对了。
该数据库大约有7K行。
试试这个:
SELECT `u`.`id`, `u`.`fname`, `u`.`lname`, `u`.`customer_id`, `u`.`email`, `u`.`partner_id`, `u`.`campaign_promocode`, `u`.`utm_medium`, `u`.`referrral_source`, `u`.`is_active`, `u`.`created_at`, `ug`.`group_id`
FROM (`users` as u)
JOIN `users_groups` as ug ON `ug`.`user_id` = `u`.`id`
WHERE (`ug`.`group_id` = '99' OR `ug`.`group_id` = '100' )
AND `u`.`is_active` IN ('1', '2')
AND `u`.`fname` LIKE '%sandeep%'
ORDER BY `u`.`id` desc
LIMIT 10
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句