34,333
edits
Changes
→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>
