How to make a request correctly or what alternative can be done in php?

Question

SQL

The task is such that I have cities in a table with id, I received several ids and I need to get them all, I see two options here through in or make several queries through a loop or a function call. In in when two identical ids come to me, only one city for two id will be returned to me, in the second case, it’s probably not reasonable to make a query to the database every time, tell me what to do, it’s not necessary to change the logic in sql, you can also in php

Answer 1

Solved the problem with inner join

Answer 2

In in when two identical ids come to me, only one city for two id will be returned to me

You have a bit of a logic problem here. If we tell you through PHP a request for one city ID came 5 times, then you make a request 1 time, and then through PHP process the response from the DB and display this city 5 times.

Answer 3

(something like that, but not tested...)

SELECT *
FROM `table`
WHERE EXISTS(select 1 from `table` WHERE id IN (1,1,3,1,5))