Good morning guys.
Assuming a business rule where I have restaurants, and each user can follow several restaurants, I create a table_restaurant , table_user and table_restaurante_usuario_continued . So when a user starts to follow a restaurant, a record in the restaurant_table_folder_folder is created, saving the id_restaurant and user_id. So good.
My question is this: assuming my user is logged in to my app, when I list restaurants, I want all restaurants to be shown, but in the query a column is created that says whether or not the logged in user restaurant. Is it possible and feasible to achieve this result through a Mysql query?