mysql 逗号 join_mysql – sql join表,其中1列有逗号

当我搜索“new1”时,如何获取所有用户名.例如：我应该得到A和B作为用户ID 1,2在tblC中是1,2对于row1有新的1.我应该使用什么查询来获得上述结果？

我非常感谢任何帮助.谢谢你.

http://sqlfiddle.com/#!2/1ab8e/2

CREATE TABLE if not exists tblA

(

id int(11) NOT NULL auto_increment ,

user varchar(255),

category int(255),

PRIMARY KEY (id)

);

CREATE TABLE if not exists tblB

(

id int(11) NOT NULL auto_increment ,

username varchar(255),

userid int(255),

PRIMARY KEY (id)

);

CREATE TABLE if not exists tblC

(

id int(11) NOT NULL auto_increment ,

nname varchar(255),

userids varchar(255),

PRIMARY KEY (id)

);

INSERT INTO tblA (user, category ) VALUES

('1', '1'),

('1', '2'),

('1', '3'),

('1', '1'),

('2', '1'),

('2', '1'),

('2', '1'),

('2', '1'),

('3', '1'),

('2', '1'),

('4', '1'),

('4', '1'),

('2', '1');

INSERT INTO tblB (userid, username ) VALUES

('1', 'A'),

('2', 'B'),

('3', 'C'),

('4', 'D'),

('5', 'E');

INSERT INTO tblC (id, nname,userids ) VALUES

('1', 'new1','1,2'),

('2', 'new2','1,3'),

('3', 'new3','1,4'),

('4', 'new4','3,2'),

('5', 'new5','5,2');

查询到目前为止：

select * where nname="new1" from tblC

CROSS JOIN tblB

ON tblB.userid=(SELECT userids FROM substr(tblC.userids,','))