17,377
社区成员
发帖
与我相关
我的任务
分享
select * from table_1 where answer not like '%?%'
SQL> select id from tb_test where remark like '%?%' or remark like '%?%';
ID
----------
1
2
SQL> select id from tb_test
2 where id not in (select id from tb_test where remark like '%?%' or remark like '%?%');
ID
----------
3
SQL>