How to check SQL lite intersection?

Question

Python

There are such lines: 'eng, anime' and 'eng, history' their intersection returns True. How do I make a query in SQL lite with an intersection check? 'eng, anime' and 'rus, history' must return False

Answer 1

SELECT * FROM memes WHERE tags LIKE "%anime%" OR tags LIKE "%eng%"

In this case, if the tags field of the entry contains "anime" or "eng", then such an entry will be displayed in the list of found ones.
And if it doesn't, it won't be on the list. Is this the intersection you want?
Read more about how to correctly format tags in the tags field of the memes table here

Answer 2

Join

Answer 3

Damn, I don't understand what the intersection is. Do strings start with one substring? Then select this substring and use like