正常情况下,下面这段sql执行起来毫无问题
select * from student where id in ('id1','id2')
但是当在程序中拼接出这条sql时却出现了问题
String sql = "select * from student where id in (?)"
String ids = "id1,id2"
发现它只把id=“id1”的数据查了出来,后面的数据没有查出来,之后将其改成如下形式完美解决
String sql = "select * from student where FIND_IN_SET(id,?)"
String ids = "id1,id2"