Shingles algorithm and mysql?

Question

MySQL

I have a table of texts.
Each has shingles - I store each shingle in a separate table.
I want to add a new text to the database - I make shingles for it and I need to compare it with those that already exist, i.e. find matches (intersections).
How to do this using mysql i.e. in php for example it is array_intersect ?
Thank you.

Answer 1

It all depends on the organization of the base and what you want to get.
Usually this is done via (for)each in stored procedures.