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, 1484🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...