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

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

Please suggest a solution

Options: ReplyQuote

Written By
Search on phonenos
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.