Question

SQL语句传入一个函数的参数是一个用分号隔开的多个值怎么办???

Answer 1

SELECT * from table1 where name in (select ''''+replace('aaa;bbb;ccc;ddd',';',''',''')+'''')