[Resolved] LIKE one to make LIKE one, and two, and three How?

[skeetley]

This is my query string that works:

$query = "SELECT * FROM ".$product.", Stations WHERE (".$product.".FMFP_ID=Stations.FMFP_ID) AND (Stations.grp LIKE '%".$region."%') ORDER by 'grp','pos'";

$region is selected by a pull down menu

<select name="region" id="region">
          <option value="C">South Shield</option>
          <option value="D">Northwest Boreal</option>
          <option value="F">Central Boreal</option>
          <option value="G">East Boreal</option>
        </select>

Now I have a few more regions to add later, but I want to make an "All Regions" option. I can't figure out what to put in the option value for such an option and still have my string work. Or do I need to re-write my query? Thanks.

[Lars_Berg]

<option value="%">All</option>

[skeetley]

That works beautifully, thanks!