From: | "Mike Poe" <trolling4dollars(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Question - Query based on WHERE OR |
Date: | 2007-01-11 01:38:38 |
Message-ID: | 1168479517.968077.279130@p59g2000hsd.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2007-01-11 01:40:12 | Re: Moving the database from winxp to linux |
Previous Message | Jeff Davis | 2007-01-11 01:32:57 | Re: tsearch2 headline() query subselect help |