title: How to use properly IN clause getting the value from another column in MySQL?
body: <p>In one table I have a list of cities and in another a list of clients. On clients I have a varchar column identifiend a list of cities separated by commas (ex: &quot;2,3,4&quot;).</p>
  <p>When I tried to list the cities of a client it is shown just the first city of the list.
  It seem that is adding some quotation marks on the value like:</p>
  <p>select GROUP_CONCAT(city.name)
  from city where city.id_city in ('2,3,4')</p>
  <p>¿How can avoid this situacion?</p>
  <p><a href="https://dbfiddle.uk/?rdbms=mysql_5.6&amp;fiddle=a70c667e820c3208053b324075b0462c" rel="nofollow noreferrer">https://dbfiddle.uk/?rdbms=mysql_5.6&amp;fiddle=a70c667e820c3208053b324075b0462c</a></p>
  <pre><code>CREATE TABLE `city` (
    `id_city` int(11) NOT NULL,
    `name` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`id_city`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  CREATE TABLE `client` (
    `id_client` int(11) NOT NULL,
    `name` varchar(45) DEFAULT NULL,
    `cities` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`id_client`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  INSERT INTO city (id_city,name) VALUES ('1','New York');
  INSERT INTO city (id_city,name) VALUES ('2','Boston');
  INSERT INTO city (id_city,name) VALUES ('3','San Diego');
  INSERT INTO city (id_city,name) VALUES ('4','Seatle');
  INSERT INTO city (id_city,name) VALUES ('5','Chicago');
  
  INSERT INTO client (id_client,name,cities) VALUES ('1','Client_1','2,3,4');
  
  select client.id_client, client.name, (select GROUP_CONCAT(city.name) 
  from city where city.id_city in (client.cities)) as cities from client;
  </code></pre>