求mysql一查询语句问题,在线等

Question

select * from users where user_code in (select assigned_user_code  from assignment)users 表字段user_code 是  employee单独形式
assignment表字段assigned_user_code 是employee,emp等多个user_code形式以逗号分隔
现我想提出所有包含有employee这个用的,所有assigned 信息

Answer 1

我是不是可以这样理解：table 1 :users
                     user_code     ...
                         1
                         2
                         3
                    table 2:assignment
                         assignment_id          assigned_user_code
                              1                         1,2
                              2                           1
                              3                           2

Answer 2

SELECT * FROM assignment WHERE assigned_used_code LIKE employee;