MySQL Forums
Forum List  »  Full-Text Search

Search on phonenos
Posted by: Smitha Sankaran
Date: September 01, 2005 11:22PM

I need to search on number against the fields phone no , alternate phone no and mobile no . I have full text index applied on all the three columns .

While searching for a number 280010 , if the field contains the data in following format

1.80-288010
The row is fetched and displayed since it checks for a word
2.80288010
No result fetched since full text search is on a word


Please suggest a solution

Options: ReplyQuote


Subject
Views
Written By
Posted
Search on phonenos
2940
September 01, 2005 11:22PM


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.