MySQL - Using LIKE Conditions in MySQL

Home > MySQL

Using LIKE Conditions in MySQL

Q

How To Use LIKE Conditions in MySQL?

✍: FYIcenter.com

A

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 is used to provide the escape character in the pattern.

The following tutorial exercise provides you some good pattern matching examples:

SELECT 'FYIcenter.com' LIKE '%center%' FROM DUAL;
   1

SELECT 'FYIcenter.com' LIKE '%CENTER%' FROM DUAL;
   1
   -- Case insensitive by default

SELECT 'FYIcenter.com' LIKE '%CENTER_com' FROM DUAL;
   1

⇒Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2018-03-24, 516👍, 0💬

Using Regular Expression with REGEXP in MySQL
How To Use Regular Expression in Pattern Match Conditions in MySQL? 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.*' FRO... 2018-03-24, 663👍, 0💬

Converting Character Strings to Numeric Values in MySQL
How To Convert Character Strings to Numeric Values in MySQL? You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) FROM DUAL; 4123.46 -- Very poor co... 2018-03-28, 654👍, 0💬

Using IN Conditions in MySQL
How To Use IN Conditions in MySQL? 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; 1 SELECT 3 NOT IN (1,2,3,4,5) FRO... 2018-03-28, 649👍, 0💬

Using LIKE Conditions in MySQL
How To Use LIKE Conditions in MySQL? 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 is used to provide the escape char... 2018-03-24, 517👍, 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.