34,333
edits
Changes
→Matching by Text Position
<td>[[:<:]]<td>End of word</td>
</table>
For example, to search for text that begins with a digit:
mysql> SELECT prod_desc FROM product WHERE prod_desc REGEXP '^[[:digit:]]';
+--------------------+
| prod_desc |
+--------------------+
| 4 Port USB Hub |
| 5 SATA Disk Drives |
+--------------------+
2 rows in set (0.00 sec)