Mysql CONCAT FIND_IN_SET用法

为什么80%的码农都做不了架构师？>>>   

SELECT id,title,TYPE,banner img,url,readCount,sort FROM ads WHERE CONCAT(',',oid,',') LIKE '%,050101,%' AND STATUS = 1 ORDER BY sort ASC LIMIT 6

SELECT menuIds FROM menu_app WHERE oid='01030201'
SELECT * FROM menu c WHERE  FIND_IN_SET(id, (SELECT menuIds FROM menu_app WHERE oid='01030201') )   ORDER BY sort ASC
SELECT * FROM menu c WHERE  id IN (SELECT menuIds FROM menu_app WHERE oid='01030202')

转载于:https://my.oschina.net/360yg/blog/1939176