Newbie question
Hi
I am going to search an database containing name, address and zip-code. Users should be able to enter name, address and a zip code in order to find the address in my database.
I would like to use FULLTEXT-search on both the name and address-field, due to typing errors etc. are common int those two fields.
Something like this:
SELECT *,
MATCH(name,address) AGAINST('Name') AS score
FROM vcard
WHERE MATCH(name,address) AGAINST('Name') AND where zip=[zipcode]
ORDER BY score DESC ;
Could be used to search for the name or the address in a certain zip-area. But how do I combine the search, so I get a fulltext search on both the name AND address in a certain zip-area?
Hope you an help me
Kind regards Henrik
Subject
Views
Written By
Posted
Newbie question
3282
March 17, 2007 11:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.