MySQL - Searching in a multiple value field <p>In my database table I have the following fields:</p> <p>Table Supplier:</p> <ul> <li>id</li> <li>name</li> <li>vehicles</li> </ul> <p>A supplier can have multiple vehicles. The field 'vehicles' will store multiple values. At the moment I am delimiting the values on a 'pipe' symbol, although this can be changed to a comma if need be.</p> <p>On my front-end form I have a checkbox list - a user can select multiple vehicles. The back end script needs to do a search and bring back all suppliers that contain any of the specified vehicle id's.</p> <p>So in other words we are searching with multiple values in a multiple value field.</p> <p>The checkbox list name is vehicle_type[] and will end up in the $_POST array as (for example):</p> <pre><code>Array ( [0] =&gt; 1 [1] =&gt; 4 [2] =&gt; 6 ) </code></pre> <p>Is this possible to do? I could obviously do this using a join table but ideally I would like to do it this way. I am using PHP as my scripting language if that helps.</p>