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 по дате отправления: