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?

What is the user's list response when the product is removed?
want to ask a question see what everyone does suppose there is an item < 1 the user sets up a list after buying item A, and uses the relational database to find 1 and then go to the information table product to introduce purchased goods suppose one...

Database-design mysql mysqli php7 php

Apr.14,2021
Find out the data that do not exist in the two tables.
assume that the current user_id = 1 uc table prod_id user_id 102 1 103 1 cs table prod_id user_id 102 1 I want to find out 103, that is, those data that are available in the uc table but not in the cs table SELECT uc.prod_id F...

Mysql mysqli php7 php

Sep.25,2021