title: Is it possible to do "reverse" prefix search
body: <p>I have a table with these columns:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>a</td>
  </tr>
  <tr>
  <td>2</td>
  <td>a.b</td>
  </tr>
  <tr>
  <td>3</td>
  <td>a.b.c</td>
  </tr>
  <tr>
  <td>4</td>
  <td>a.b.c.d</td>
  </tr>
  <tr>
  <td>5</td>
  <td>d</td>
  </tr>
  <tr>
  <td>6</td>
  <td>d.e</td>
  </tr>
  <tr>
  <td>7</td>
  <td>d.e.f</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>If I run query:</p>
  <pre><code>SELECT id FROM table WHERE name LIKE 'a%'
  </code></pre>
  <p>I can get <code>1</code>, <code>2</code>, <code>3</code> and <code>4</code>.  However, is it possible to do the <strong>reverse</strong>, such as:</p>
  <pre><code>SELECT id FROM table WHERE prefix_match(name, 'a.b.c')
  </code></pre>
  <p>which will return <code>1</code>, <code>2</code>, <code>3</code>, but <strong>not</strong> <code>4</code>.</p>
  <p>Does MySQL have such <code>prefix_match</code> logic?</p>