title: Select rows which a string starts with
body: <p>I have a string <code>/path/to/project/subdirectory/</code> and need to find a row where <code>path</code> is <code>/path/to/project/</code>.</p>
  
  <p>How can I find rows where my string starts with <code>path</code>?</p>
  
  <p>It would be the opposite of:</p>
  
  <pre><code>SELECT * FROM projects WHERE path LIKE "/path/to/%"
  </code></pre>
  
  <p>Because I have too many characters, not too few.</p>
  
  <hr>
  
  <p>Both of these return zero rows:</p>
  
  <pre><code>SELECT * FROM projects WHERE path LIKE "/path/to/project/subdirectory/%"
  SELECT * FROM projects WHERE "/path/to/project/subdirectory/" LIKE (path+"%")
  </code></pre>