Good day, users! Help please compile the right MySQL query. My question is as follows: There is a table in which “tags” are stored and nothing more .. In another “News” table there is a “tags” field that contains IDs of tags I entered, for example, 1, 2, 4, 7.
I pass the tag to the function and I need to sort all the news with this tag.
I do not want to use in the table a selection of the field "tags" through WHERE LIKE "%%" . Can you help and suggest a good and correct alternative without the WHERE tags LIKE "%%" ?