title: Find MySQL DB rows with a match in a pipe delimited column
body: <p>I'm querying a table that has a column with member_ids stuffed in a pipe delimited string. I need to return all rows where there is an 'exact' match for a specific member_id. How do I deal with other IDs in the string which might match 'part' of my ID?</p>
  
  <p>I might have some rows as follows:</p>
  
  <pre><code>1|34|11|23
  1011
  23|1
  5|1|36
  64|23
  </code></pre>
  
  <p>If I want to return all rows with the member_id '1' (row 1, 3 and 4) is that possible without having to extract all rows and explode the column to check if any of the items in the resulting array match.</p>