title: SELECT in WHERE LIKE clause
body: <p>so I have 2 tables country_codes and Database.
  I need to retrive all columns from the database if the country code exist on the table country codes. For example, I have 123 on my country codes table, I need
  to select all columns if the Phone_Number Column's first 3 digit is 123. So I will select the number 1234567.</p>
  
  <p>Table Name : Country_Codes</p>
  
  <pre><code>+---------------+
  |Country_Code   |
  +---------------+
  |   123         |
  |   456         |
  |   556         |
  |   231         |
  +---------------+
  </code></pre>
  
  <p>Table Name : Database</p>
  
  <pre><code>+---------------+--------+
  |Phone_Number   | Used   |
  +---------------+--------+
  |   1234567     |  No    |
  |   4568823     |  No    |
  |   5562143     |  No    |
  |   5582143     |  No    |
  |   2319042     |  No    |
  +---------------+--------+
  </code></pre>
  
  <p>The Result that I want is </p>
  
  <p>Table Name : Database</p>
  
  <pre><code>+---------------+--------+
  |Phone_Number   | Used   |
  +---------------+--------+
  |   1234567     |  No    |
  |   4568823     |  No    |
  |   5562143     |  No    |
  |   2319042     |  No    |
  +---------------+--------+
  </code></pre>
  
  <p>I have tried using</p>
  
  <pre><code>SELECT * FROM database 
  WHERE database.phone_number LIKE (SELECT country_code FROM country_codes);
  </code></pre>
  
  <p>But I keep on getting an error.</p>