title: SELECT * FROM tbl WHERE clm LIKE CONCAT('%',<other sql query LIMIT 1>,'%') - HOW?
body: <h2>How can I combine those two queries into one?</h2>
  
  <p>1) This finds the japanese sign for dog (犬):</p>
  
  <pre><code>SELECT japanese 
    FROM edict 
   WHERE english LIKE 'dog' 
   LIMIT 1;
  </code></pre>
  
  <p>2) This finds all japanese words with the sign for 'dog' (犬) in it:</p>
  
  <pre><code>SELECT japanese 
    FROM edict 
   WHERE japanese LIKE '%犬%';
  </code></pre>
  
  <hr>
  
  <p>3) I am having trouble combining those two into one, because this doesn't work?!</p>
  
  <pre><code>SELECT japanese 
  FROM edict 
  WHERE japanese
  LIKE CONCAT('%',
      SELECT japanese FROM edict WHERE english LIKE 'dog' LIMIT 1,'%'
  );
  </code></pre>