MySQL Forums
Forum List  »  Full-Text Search

Re: How to search based on first LETTER of consecutive words
Posted by: rubs sin
Date: April 29, 2013 02:02PM

Great, Thanks a lot.

Actually [[:<:]] is working fine for Indian text and moreover the following query you mentioned is also working great:
WHERE CONCAT(' ', REPLACE(`Scripture`, ',', ' ')) RLIKE
' ਦ[[:alpha:]]* +ਦ[[:alpha:]]* +ਦ'

This is finding first alphabet of consecutive words anywhere in the line(text), is it possible to restrict it to start checking from first word and only return result if matching starts from first word of the the line.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to search based on first LETTER of consecutive words
2402
April 29, 2013 02:02PM


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.