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, 409👍, 0💬

Using CASE Expression in MySQL
How To Use CASE Expression in MySQL? 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 based on a list of conditions. Here ... 2018-03-24, 554👍, 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, 526👍, 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, 524👍, 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, 410👍, 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.