I want to create a table where every user is matched with other users based on values in their user table.
Example: User X has category preference. They are stored in a “category” column, which is a list.
Once a day, I want (automatically) to search through every user in the database (there are not a lot of them), and when another user (let’s say user Y) has one or more similar categories, they count as a "match.
The table should show user ID 1, User ID 2, matched categories (as a list)