从apply_jobs中选择*，其中appid如'％RAD-0001％'和job_id IN（'41,48,49'）按id asc排序

Question

getting query empty with this query. butt data is there in database

 select * from applies_jobs where appid like '%RAD-0001%' and  job_id IN ('41,48,49') order by id asc

if i use only in or like query it work fine.

Answer 1

try this:

select * from applies_jobs where appid like '%RAD-0001%' and  job_id IN ('41','48','49') order by id asc

in the IN use separated values