How to get multiple records from serialized data using sql?

Question

MySQL

There is a table in which the data field (longblob data type), user sessions are stored in it.

__flash|a:0:{}user.attribute|s:3:"---";__id|s:1:"1";

How can I get records of specific users by id (__id) ?
Perhaps this can be done using yii2 (I did not find it in the docks).
For example, I want to find records of user sessions with id 1 and 7 and log them out.

Answer 1

The only normal solution would be to have a separate column with user_id.

Answer 2

Brute force -> unserialize -> log out
Or pervert with a like request, the first option is easier

Answer 3

Search using regular expressions