clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 818513 fiddles created (9187 in the last week).

CREATE TABLE blog(id integer, blog_title varchar(20), tags varchar(20));
 hidden batch(es)


INSERT INTO blog (id,blog_title,tags) VALUES(1,'Hi','台北,高雄,屏東');
 hidden batch(es)


INSERT INTO blog (id,blog_title,tags) VALUES(2,'你好','台北,高雄');
 hidden batch(es)


INSERT INTO blog (id,blog_title,tags) VALUES(3,'早安','屏東,彰化');
 hidden batch(es)


SELECT * FROM blog
 hidden batch(es)


SELECT id,blog_title FROM blog WHERE tags REGEXP ( SELECT replace(tags,',','|') FROM blog where 1=1 and id=1 ) and id <> 1
 hidden batch(es)


SELECT id,blog_title FROM blog WHERE tags REGEXP ( SELECT replace(tags,',','|') FROM blog where 1=1 and id=2 ) and id <> 2
 hidden batch(es)


SELECT id,blog_title FROM blog WHERE tags REGEXP ( SELECT replace(tags,',','|') FROM blog where 1=1 and id=3 ) and id <> 3
 hidden batch(es)