mysql - SQLworkbench中有关LIKE子句和Select语句的查询

Question

我想通过执行以下查询从数据库检索数据:

  Select * from Employee emp
inner join Department dept on emp.empid=dept.empid
where dept.OrderID like '%1' OR
      dept.OrderID  like '%,1' OR
      dept.OrderID  like '%,1,%' OR
      dept.OrderID  like '1,%'
order by ..;

** 上述条件是--> 1 OR 2,1 OR 2,1,3 OR 1,2

我想传递 select 语句(从 OrderName= 'ABCD' 的订单中选择 OrderID，其中 OrderName= 'ABCD')，而不是上面的查询中的 '1'。

我已经尝试过，但没有掌握语法。请任何人都可以建议我如何正确执行此操作。谢谢。

Answer 1

试试这个:

     Select * from Employee emp
    inner join Department dept on emp.empid=dept.empid
    where dept.OrderID like CONCAT('%', (select OrderID from Orders where OrderName= 'ABCD')) OR
          dept.OrderID  like CONCAT('%,', (select OrderID from Orders where OrderName= 'ABCD')) OR
          dept.OrderID  like CONCAT('%,', (select OrderID from Orders where OrderName= 'ABCD'), ',%') OR
          dept.OrderID  like CONCAT((select OrderID from Orders where OrderName= 'ABCD'), ',%')
order by ..;