Find other similar articles? A,B,C.

hypothetical articles have a bit called tags that he has finished.
every article has a similar tag, for example, 

id / blog_title / tags
1 / Hi / A,B,C
2 /  / A,B
3 /  / C,D

I want to use tags to find other articles that are similar to this article
hypothesis. I am now writing article 1 . Under
, there will be an extension. He will find articles with similar headings like him and show
, so he will show article 2 and article 3
. If you click article 2 , only will be shown. [ID: nbsp; nbsp. Then it will only show article 1 as his extension 

SELECT blog_title FROM `blog`
        WHERE tags LIKE "%{ ??? }%"
        LIMIT 3

what function can I use in mysql or php to make this comparison?
is to use the article"s own tag to find other matching tag

Mysql mysqli php7 php
Sep.16,2021

I suggest that tags separate a table and then add an intermediate table to maintain the relationship between the article and tags, so that the query and later maintenance will be better

I think the better way is to like, after using explode, but there is no explode method in mysql. You can refer to this article. Create an explode
https://stackoverflow.com/que.
or you can use php as a secondary, explode 

SELECT
  blog_title
FROM
  blog
WHERE
  tags RLIKE
  CONCAT('[[:<:]]', REPLACE('A,B,C', ',', '[[:>:]]|[[:<:]]'), '[[:>:]]')

A code B < C, replace it with your parameter placeholder

{?} (I don't know what software uses such a weird placeholder)

[[: <:]] and [[: >:]] denote the boundary of a word , which can be punctuation or the beginning and end of a character.

rlike means regular match.

find_in_set ?

Previous: The use of element el-scrollbar

Next: What commands does linux have to display the results vertically?

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-42e8a76-c1e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-42e8a76-c1e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?