How to properly exclude certain products from the selection?

Question

SQL

It is necessary to remove from the list of games those that are already in the Steam account. The array of games on the account is written to the database via serialize. Each game has its own id. How to remove from the selection the games in which the id matches the one in the serialized array?

Answer 1

The array of games on the account is written to the database via serialize.

In a situation where you need to perform some kind of action on the data, writing them in one serialized field is a stupid plan.
many-to-many

Answer 2

SELECT id FROM table WHERE id NOT IN (SELECT `id` FROM `table2`)
after not in make a query to the user's table, for example, with his games