title: Getting certain parts of a string out of a select
body: <p>I have a database (mydb) with following data in one column:</p>
  
  <p><strong>PK:</strong> </p>
  
  <ul>
  <li>8/10/6101+6102 (2971386)  </li>
  <li>6110/2411 (3037457)  </li>
  <li>8/10/6504 (2276770)</li>
  <li>8/10/6403 (2724296)    </li>
  <li>-2669938  </li>
  <li>8/1/1001-1031 (2857109)    </li>
  <li>-2547251</li>
  <li>8/9/5003-5006 (2770096)</li>
  </ul>
  
  <p>I have to compare these data with a variable <code>$id</code> for example: 2724296</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM mydb WHERE PK = '$id';
  </code></pre>
  
  <p>Of course, this query won't deliver a result. Is there a easy way to compare my $id with the values in the brace and the values with no brace? A replace in the select replaces e.g. only the brace, but not the value left to the brace.</p>
  
  <p>Greets, Yab86</p>