find_in_set
2018-03-24 本文已影响42人
维乾
参考文章(https://www.cnblogs.com/flintlovesam/p/6832485.html)
新建两个表,

SELECT * FROM T_CATEGORY c WHERE (SELECT FIND_IN_SET(c.C_ID,t.T_CATEGORYS) from T_TOPIC t where t.T_ID=2)
如何执行该语句

参考文章(https://www.cnblogs.com/flintlovesam/p/6832485.html)
新建两个表,
SELECT * FROM T_CATEGORY c WHERE (SELECT FIND_IN_SET(c.C_ID,t.T_CATEGORYS) from T_TOPIC t where t.T_ID=2)
如何执行该语句