MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE blog(id integer, blog_title varchar(20), tags varchar(20));
INSERT INTO blog (id,blog_title,tags) VALUES(1,'Hi','台北,高雄,屏東');
INSERT INTO blog (id,blog_title,tags) VALUES(2,'你好','台北,高雄');
INSERT INTO blog (id,blog_title,tags) VALUES(3,'早安','屏東,彰化');
SELECT * FROM blog


id
blog_title
tags


1
Hi
台北,高雄,屏東

2
你好
台北,高雄

3
早安
屏東,彰化


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


id
blog_title


2
你好

3
早安


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


id
blog_title


1
Hi


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


id
blog_title


1
Hi

id	blog_title	tags
1	Hi	台北,高雄,屏東
2	你好	台北,高雄
3	早安	屏東,彰化