1.开始的时候一直在将字符串str转换为类似的in参数,如下
SELECT * FROM stocks_orderlist s where s.scode in ("0001ME","0002BL") LIMIT 10; SELECT CONVERT(CONCAT("\'",REPLACE("0001ME,0002BL","\,","\'\,\'"),"\'"),CHAR); SELECT * FROM stocks_orderlist s where s.scode in (CONVERT(CONCAT("\"",REPLACE("0001ME,0002BL","\,","\"\,\""),"\""),CHAR)) LIMIT 10;
2.instr函数,看帮助文档的意思是找出substr在str中第一次出现问题,尝试如下
SELECT INSTR("0001ME,0002BL","0003ME"); SELECT INSTR("0001ME,0002BL","0001ME"); SELECT INSTR("0001ME,0002BL","0002BL"); SELECT * FROM stocks_orderlist s where INSTR("0001ME,0002BL",s.scode);
总结:看起来很小的一个方法,假如不知道方法的时候却很痛苦啊。
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com