Using mysql to query a table with a product code which is part of a filename
<p>I am trying to query a table which has a column called "filename".</p>

<p>The actual filename is made up of "productcode-category.jpg"</p>

<p>If i have the product code posted to a php page, how could i then take the value and search in the filename column where it equals the product code?</p>

<p>It would be great if it wasnt case sensitive as well.  </p>
