How to get all chats that have a user?

Question

MySQL

There is a chats column in the database

, you need to get all the chats in which his id is mentioned by the user id (i.e. in users)

Answer 1

More or less like this:

$users[] = 1; // ID пользователя

$q = "SELECT * FROM table regexp '(" . implode( '|', $users) . ")";

But I recommend reading about the normalization of relationships in the database and bring the structure of the current database to 3 normal form :

users
id, first_name, last_name, ...

chats
id, user_id, name, ...

chats_users
chat_id, user_id

UPD:
https://www.w3schools.com/sql/func_mysql_find_in_s...