Richards and List,
Now I find out the 'similar to' statement where I can do such search, but I
must still parse all substrings.
Here is my stage:
Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%')
But I still need to Separete all strings.
Could someone help me in this crusade ?
Regards
Ezequias
Em Tue, 27 Mar 2007 15:16:10 -0700 (PDT) Richard Broersma Jr <rabroersma@yahoo.com> escreveu:
>> Could you give me a hand ?
>>
>> I have a ZipCode table and my address table
>>
>> I just would like to find out all matches that my zipcode table has where my
>> address table appears like this:
>>
>> Elmo Street, 30
>>
>> I would like my SQL find out all matches we can find 'Elmo', 'Street'.
>>
>
>select zipcode
>from zipzodetable
>where address ~ 'Elmo'
>and address ~ 'Street';
>
>If the query is too slow I expect that installing the tsearch2 contrib module
>and using the
>tsearch2 type queries would give you want you wanted but in a fraction of the
>time.
>
>Regards,
>Richard Broersma Jr.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
--
Ezequias Rodrigues da Rocha