Match the beginning and end of words, respectively( [[ : Word : Regular Expressions MySQL TUTORIALS


MySQL TUTORIALS » Regular Expressions » Word »

 

Match the beginning and end of words, respectively( [[


mysql>
mysql> SELECT 'a word a' REGEXP '[[:<:]]word[[:>:]]';
+----------------------------------------+
'a word a' REGEXP '[[:<:]]word[[:>:]]' |
+----------------------------------------+
|                                      |
+----------------------------------------+
row in set (0.00 sec)

mysql>
mysql> SELECT 'a xword a' REGEXP '[[:<:]]word[[:>:]]';
+-----------------------------------------+
'a xword a' REGEXP '[[:<:]]word[[:>:]]' |
+-----------------------------------------+
|                                       |
+-----------------------------------------+
row in set (0.00 sec)

mysql>
mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Regular Expressions
» Word