MySQL Forums
Forum List  »  Full-Text Search

How to search based on first alphabet of consecutive words
Posted by: rubs sin
Date: April 02, 2013 03:28PM

Hi,

We have a requirement to search for first alphabet of the consecutive words, for example if the column contains values:
This is new car
This is car new
This is old car
Tin is old

When user search for "tin" then it should only return first row since t i n are 1st alphabet of consecutive words. We can do following in SQL Server so trying to find equivalent fulltext query in mysql:
SELECT * FROM dbo.TBL_NAME
WHERE contains(field_name,N'"t* i* n*"') ;

Options: ReplyQuote


Subject
Views
Written By
Posted
How to search based on first alphabet of consecutive words
5474
April 02, 2013 03:28PM


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.