MySQL Forums
Forum List  »  Full-Text Search

Newbie question
Posted by: henrik lauritzen
Date: March 17, 2007 11:54AM

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

Options: ReplyQuote


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.