mysql取出当前文章所有的标签的sql语句

2025-03-24 22:42:38
推荐回答(2个)
回答1:

文章表为T1
标签分类表为T2
select T1.cid, T2.name
from T1

join T2

on T1.mid = T2.mid

where T1.cid = 3;

回答2:

"select * from biao where cid='3' and category='tag'"