MySQL Forums
Forum List  »  Full-Text Search

Re: How to search based on first LETTER of consecutive words
Posted by: Rick James
Date: April 30, 2013 08:10PM

WHERE CONCAT(' ', REPLACE(`Scripture`, ',', ' '))
 RLIKE '^ *ਦ[[:alpha:]]* +ਦ[[:alpha:]]* +ਦ' 

"^" 'anchors' the regexp at the start.
After that, ' *' allows 0 or more spaces.  The spaces might come from punctuation at the start of the string.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to search based on first LETTER of consecutive words
1974
April 30, 2013 08:10PM


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.