mysql - 如何在mysql中为IN子句添加一个额外的值

Question

我有一个包含查询的 In 子句。我想在那个 IN 中添加“NULL”。我该如何添加。

这是我的问题

WHERE `e`.`lead_id` IN (
    select lds.lead_id 
        from mortgage_lead_leads lds 
        where lds.loan_officer_id=60
)

给出了 10 条记录。我想向该 In 子句添加另一条记录。谁能帮帮我。

Answer 1

你可以使用 unio 和 select null from dual

  WHERE `e`.`lead_id` IN 
  (select lds.lead_id from mortgage_lead_leads lds 
    where lds.loan_officer_id=60 
    union 
   select null from dual )

或一个or子句

   WHERE `e`.`lead_id` IN 
  (select lds.lead_id from mortgage_lead_leads lds 
    where lds.loan_officer_id=60 ) or `e`.`lead_id` is null