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, 1954🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...