34,333
edits
Changes
→Matching by Text Position
For example, to search for text that begins with a digit:
<pre>
mysql> SELECT prod_desc FROM product WHERE prod_desc REGEXP '^[[:digit:]]';
+--------------------+
+--------------------+
2 rows in set (0.00 sec)
</pre>