Collections:
Using Regular Expression with REGEXP in MySQL
How To Use Regular Expression in Pattern Match Conditions in MySQL?
✍: FYIcenter.com
If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern condition: REGEXP. The following tutorial exercise provides you some good examples:
SELECT 'FYICenter.com' REGEXP '.*fyi.*' FROM DUAL; 1 SELECT 'FYICenter.com' REGEXP '.*com$' FROM DUAL; 1 SELECT 'FYICenter.com' REGEXP '^F.*' FROM DUAL; 1
⇒ Using CASE Expression in MySQL
⇐ Using LIKE Conditions in MySQL
2018-03-24, 1567🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...