title: PHP MySql search with LIKE matches too many rows
body: <p>I've taken over a site which uses a LIKE query to search in a field of delimited values. A typical field might look like this: </p>
  
  <pre><code>129|145|181
  </code></pre>
  
  <p>And the query looks like this:</p>
  
  <pre><code>SELECT id,title FROM research WHERE members like '$arr[0]'
  </code></pre>
  
  <p>The problem is that when this searches for, e.g. "29", it returns fields with "129" in them. I want it to only return fields with "29" in them. Is there any way of doing this?</p>
  
  <p>Thanks,
  G</p>