Re: Question - Query based on WHERE OR

Поиск
Список
Период
Сортировка
От SCassidy@overlandstorage.com
Тема Re: Question - Query based on WHERE OR
Дата
Msg-id OF8530A264.8E5A814E-ON88257261.0002EF3F-88257261.00044AED@overlandstorage.com
обсуждение исходный текст
Ответ на Question - Query based on WHERE OR  ("Mike Poe" <trolling4dollars@gmail.com>)
Список pgsql-general
Дерево обсуждения

You could have your program check to see if the lastname form field was empty, and send different queries to the database depending on what they entered.

I'm a perl person, not php, so my php syntax might not be perfect, but you'll get the idea:

if ($lastname =="") {
  $query="SELECT foo, baz, bar FROM public.table WHERE ssn='$ssn'";
} elsif (($lastname != "") and ($ssn != "")) {
  $query="SELECT foo, baz, bar FROM public.table WHERE lastname ~* '$lastname' OR ssn='$ssn'";
}

then execute the query

or, get fancy, and build the where clause:

if ($lastname !="") {
  $where.=" lastname ~* '$lastname'";
}
if ($ssn != "") {
   if ($where != "") {
      $where.=" OR ";
   }
 $where.=" ssn='$ssn'";
}

$query="SELECT foo, baz, bar FROM public.table WHERE  $where";

Then, run the query.

Just a couple of ideas.

Susan Cassidy



"Mike Poe" <trolling4dollars@gmail.com>
Sent by: pgsql-general-owner@postgresql.org

01/10/2007 05:38 PM

To
pgsql-general@postgresql.org
cc
Subject
[GENERAL] Question - Query based on WHERE OR





I'm a rank newbie to Postgres & am having a hard time getting my arms
around this.

I'm trying to construct a query to be run in a PHP script.  I have an
HTML form were someone can enter either a last name or a social
security number & then query the database based on what they entered.

My query looks like this:

SELECT foo, baz, bar FROM public.table WHERE lastname ~* '$lastname' OR
ssn='$ssn'"

I need to leave the last name a wildcard in case someone enters a
partial name, lower case / upper case, etc.

I want the SSN to match exactly if they search by that.

The way it's written, if I enter nothing for the last name, it returns
all rows, regardless of what I enter for the ssn.

I understand why it happens, but what can I do to return the desired
results?

Thank you.
Mike


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq



----------------------------------------------------------------------------------------------
Simply protected storage solutions ensure that your information is
automatically safe, readily available and always there, visit us at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------

В списке pgsql-general по дате отправления:

Предыдущее
От: jam@zoidtechnologies.com
Дата:
Сообщение: Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [HACKERS] Checkpoint request failed on version 8.2.1.