2 Replies Latest reply: Feb 21, 2010 11:53 AM by David_Powers RSS

    Easy MySQL data filtering question

    Mike_Watt Community Member

      I've got a pretty dumb question.

      When creating a search query (in DW CS4), how do I specify that if a field is submitted blank, the DB should return all results?

      As in, maybe I want to find all people who live in a certain city - I would choose the city in the search form, but I would leave "name" blank, because I don't want to limit by name. So how do I tell it to not try to match blank fields and instead return all?

      Thanks in advance.

      +mf