Question

phpcms数据库两表查询，取表2中一表中的值

phpcms数据库两表查询，其中表1名称为news，表2名称为news_data,就是把news_data表中fenlei字段含有1的值查询出来，请问怎么写查询语句





Answer 1

SELECT * FROM news AS n LEFT JOIN news_data AS nd ON n.id=nd.id WHERE find_in_set(',1', fenlei)

追问

{pc:get sql="#"}{loop $data $r} {str_cut($r[title], 48, '')} {/loop}{/pc}照这样调不出来

Answer 2

select * from news_data where fenlei like "%,1,%"

追问

谢谢！表1的标题也得读出来呀