title: SQL error: #1242 - Subquery returns more than 1 row
body: <p>I got "error: #1242 - Subquery returns more than 1 row" trying to execute this Query:</p>
  
  <pre><code>SELECT id FROM postcodes WHERE pcd LIKE (SELECT CONCAT(pcd,' %') FROM towns WHERE id IN (31898,12828,15771,7604))
  </code></pre>
  
  <p>do you have any suggestion for this query?</p>