Open main menu

Changes

MySQL Regular Expression Searches

299 bytes added, 18:51, 19 October 2007
→‎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)