title: SQL LIKE clause to match closest record
body: <p>I am running this SQL Query to match records against data in a database:</p>
  
  <pre><code>SELECT * from billing_match_table WHERE 'Exchange Mailbox plus Outlook' LIKE CONCAT(description, '%');
  </code></pre>
  
  <p>so in the table, there are two rows with descriptions of:</p>
  
  <pre><code>Exchange Mailbox
  
  Exchange Mailbox plus Outlook
  </code></pre>
  
  <p>So running this Query will return both records but i want to be able to match the closest record</p>
  
  <p>the reason i use the <code>CONCAT</code> this way is because i also have records like this:</p>
  
  <p><code>Non-Geographic Number 0843123456</code> which needs to match <code>Non-Geographic Number 0843</code></p>
  
  <p>and</p>
  
  <p><code>Non-Geographic Number 0845123456</code> which needs to match <code>Non-Geographic Number 0845</code></p>
  
  <p>so how can i match these to the closest record in the database and not just the first row returned</p>