MYSQL 相关

MYSQL where id in问题

 

SELECT * FROM product WHERE id IN (‘1522,1523,1524′)ORDER BY id DESC
在MYSQL里面执行这个语句只返回1522的值。


执行

SELECT * FROM product WHERE instr(‘1522,1523,1524′,id) ORDER BY id DESC


或者


SELECT * FROM product WHERE instr(‘1522,1523,1524′,id)>0 ORDER BY id DESC