Sql join on comma separated field

SELECT * FROM `TABLE1`
JOIN `TABLE2` ON `TABLE1`.`id` = `TABLE2`.`COMMA_SEPERATED_COLUMN` 
AND `TABLE2`.`COMMA_SEPERATED_COLUMN` REGEXP "(^|,)SPECIFIC_ID(,|$)"

############## OR #######################

SELECT * FROM table1 
LEFT JOIN table2 ast ON ast.nodeid = c_NodeId 
AND ',' + ast.GroupNames + ',' LIKE '%,' + table1.GroupAlphabet + ',%';

Comma seperated join mssql

select SM.ROLLNO,
       SM.NAME, 
       SM.ADDRESS,
       (
       select ','+CM.CourseName
       from dbo.CourseMaster as CM
       where ','+SM.Course+',' like '%,'+CM.CourseId+',%'
       for xml path(''), type
       ).value('substring(text()[1], 2)', 'varchar(max)') as Course
from dbo.StudentMaster as SM;

Source: dba.stackexchange.com

Similar codes

0 vote256 views1 answer
How to display value of variable in mysql
SQL
0 vote228 views1 answer
Sqlite3 now
SQL
0 vote272 views1 answer
Multiple replace value mssql
SQL
4 votes252 views4 answers
Date less than in sql
SQL
0 vote262 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote248 views1 answer
Getting next sequence value jpa postgress
SQL
2 votes262 views2 answers
Convert_tz mysql
SQL
0 vote306 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote266 views1 answer
Drop procedure sql
SQL
0 vote254 views1 answer
Insert into select with group by
SQL