A regular expression (regex or regexp for short) is a special text string for describing a search pattern. In the SOB I am using the MySQL function REGEXP.

   MySQL allows the following regular expression metacharacters:
. match any character
? match zero or one
* match zero or more
+ match one or more
{n} match n times
{m,n} match m through n times
{n,} match n or more times
^ beginning of line
$ end of line
[abc] match one of enclosed chars
[^xyz] match any char not enclosed
| separates alternatives - e.g. (ns|si)


   Example of usage
   I want to find the words "mighty", "Almighty", "mightier", "mightest" etc., but i dont want find the word "might".

Searched term (regular expression):
- might[^ \.,;:!\?\)<]+
- or better (al)?might[^ ,;:\.!\?\)<]+ or (al)?might[^ ,;:\.!\?\)<]{1,}
- + is usually the same as {1,}, but in SOB it does not always. You can try both options.


   [ae] or (a|e) ?
- [ae] is usually the same as (a|e), but in SOB you prefer using (a|e) !!!


   Searching in translations with notes and Strong's numbers
   In the translation with notes or Strong's numbers, after individual words can immediately follow some HTML code. Eg. link to comment may be as superscript - <sup> (^note). Strong's numbers are between two asterisks - (e.g. God*H430*). So it is good protect end of the word using a regular expression - [^<] .