[RESOLVED] Searching MySQL from a Multi-Select List Menu form object,

[listenmirndt]

I am trying to search my database where the category matches, but I would like to use multiple category matches ( bring results if any of the selected categories match from a multiple-select list menu form object.

The form :

  <select name="select" size="1" multiple>
    <option>category1</option>
    <option>category2</option>
    <option>category3</option>
  </select>

Is there a simple way to build the query to sort of try to match the CATEGORY field in my database against all selections in the search?

Thanks for any help, not quite sure how to go about's this

-Arron