MySQL SQL - How To Use Regular Expression in Pattern Match Conditions

How To Use Regular Expression in Pattern Match Conditions

Q

How To Use Regular Expression in Pattern Match Conditions? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

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

2007-05-11, 4546👍, 0💬

How To Use CASE Expression
How To Use CASE Expression? - MySQL FAQs - Introduction to SQL Basics There are 2 ways to use the CASE expression. The first way is to return one of the predefined values based on the comparison of a given value to a list of target values. The second way is to return one of the predefined values bas... 2007-05-11, 4288👍, 0💬

What Are DDL Statements
What Are DDL Statements? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the defi... 2007-05-11, 4272👍, 0💬

How To Use LIKE Conditions
How To Use LIKE Conditions? - MySQL FAQs - Introduction to SQL Basics A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause i... 2007-05-11, 4258👍, 0💬

How To Use IN Conditions
How To Use IN Conditions? - MySQL FAQs - Introduction to SQL Basics An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the tutorial exercise below: SELECT 3 IN (1,2,3,4,5) FROM DUAL; ... 2007-05-11, 4227👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.