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.
Subject
Views
Written By
Posted
6914
April 02, 2013 03:28PM
3158
April 04, 2013 10:34AM
2884
April 28, 2013 11:42AM
3149
April 28, 2013 09:16PM
3326
April 29, 2013 02:02PM
Re: How to search based on first LETTER of consecutive words
2637
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.