Question - Query based on WHERE OR
От | Mike Poe |
---|---|
Тема | Question - Query based on WHERE OR |
Дата | |
Msg-id | 1168479517.968077.279130@p59g2000hsd.googlegroups.com обсуждение исходный текст |
Ответы |
Re: Question - Query based on WHERE OR
Re: Question - Query based on WHERE OR Re: Question - Query based on WHERE OR |
Список | 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
В списке pgsql-general по дате отправления: