Open main menu

Changes

MySQL Regular Expression Searches

274 bytes added, 18:53, 19 October 2007
→‎Matching by Text Position
| 5 SATA Disk Drives |
+--------------------+
2 rows in set (0.00 sec)
</pre>
 
Similarly, to search for text which ends in the word 'Phone':
 
<pre>
mysql> SELECT prod_desc FROM product WHERE prod_desc REGEXP 'Phone$';
+--------------+
| prod_desc |
+--------------+
| Smart Phone |
| Mobile Phone |
+--------------+
2 rows in set (0.00 sec)
</pre>