title: MYSQL : Select * where IN (REPLACE(...))
body: <p>I have the following request :</p>
  
  <pre><code>    SELECT value from catalog_category_entity_varchar WHERE entity_id IN
  ('1','2','10','47')
  </code></pre>
  
  <p>This request give results.</p>
  
  <pre><code>value
  ok
  ok
  ok
  ok
  </code></pre>
  
  <p>The following request</p>
  
  <pre><code>    SELECT value from catalog_category_entity_varchar WHERE entity_id IN
  (REPLACE("'1','2','10','47'", 'dont', 'care'))
  </code></pre>
  
  <p>This request doesn't give results because I think its generate <code>"'1','2','10','47'"</code> and <code>entity_id</code> is an int and not a string.</p>
  
  <p>Thus I tried the following request, but still no results</p>
  
  <pre><code>    SELECT value from catalog_category_entity_varchar WHERE entity_id IN
  (TRIM(BOTH '"' FROM REPLACE("'1','2','10','47'", 'dont', 'care')))
  </code></pre>
  
  <p>My question is how can I generate a request like the first with a replace ?
  Thank you all for your time.</p>
  
  <p>EDIT : DATA SAMPLE :</p>
  
  <pre><code>CREATE TABLE catalog_category_entity_varchar (entity_id int(10), value varchar(255));
  INSERT INTO catalog_category_entity_varchar VALUES (1,'ok'),(2,'ok'),(10,'ok'),(47,'ok');
  </code></pre>
  
  <p>The initial request I try to achieve to give results</p>
  
  <pre><code>    SELECT value from catalog_category_entity_varchar WHERE entity_id
  IN ( CONCAT('"', REPLACE('1/2/10/47', '/', '","'), '"') );
  </code></pre>