php - MySQL 从两个表中选择，其中一列包含 2 个变量

Question

我有两张 table :

第一个表是tbl_ccompany

db_id   db_cname
 1         xxx
 2         yyy

第二个表tbl_marketing

db_mid db_name db_ccompany
1       ggg     1,2

在tbl_marketing db_ccompany中包含第一个表的id

我想选择要打印的 db_cname输出将是这样的

1  ggg xxx,yyy

我尝试在这两个表之间进行左连接，但只有我收到名字

select 
marketing.*,
ccompany.db_cname
from tbl_marketing as marketing
left join tbl_ccompany as ccompany
on
marketing.db_ccompany=ccompany.db_id

我如何加入表格并获得我想要的输出？

Answer 1

我希望这有帮助。

数据库结构:

create table tbl_ccompany (
db_id int,
db_cname text );

insert into tbl_ccompany values (1,'xxx');
insert into tbl_ccompany values (2,'yyy');

create table tbl_marketing (
db_mid int ,
db_name text,
db_ccompany text
);

insert into tbl_marketing values (1,'ggg','1,2');

查询:

select db_mid, db_name, group_concat(db_cname) 
from tbl_ccompany tc , tbl_marketing tm
where find_in_set(tc.db_id,tm.db_ccompany)

引用: http://amitbrothers.blogspot.in/2014/03/mysql-split-comma-separated-list-into.html