mysql like clause

WHERE CustomerName LIKE 'a%' --Finds any values that start with "a" WHERE CustomerName LIKE '%a' --Finds any values that end with "a" WHERE CustomerName LIKE '%or%' --Finds any values that have "or" in any position WHERE CustomerName LIKE '_r%' --Finds any values that have "r" in the second position WHERE CustomerName LIKE 'a__%' --Finds any values that start with "a" and are at least 3 characters in length WHERE ContactName LIKE 'a%o' --Finds any values that start with "a" and ends with "o"

MySQL LIKE

The LIKE operator is a logical operator that tests whether a string contains a specified pattern or not. Here is the syntax of the LIKE operator:

expression LIKE pattern ESCAPE escape_character

This example uses the LIKE operator to find employees whose first names start with a:

SELECT 
    employeeNumber, 
    lastName, 
    firstName
FROM
    employees
WHERE
    firstName LIKE 'a%';
    
    This example uses the LIKE operator to find employees whose last names end with on e.g., Patterson, Thompson:

SELECT 
    employeeNumber, 
    lastName, 
    firstName
FROM
    employees
WHERE
    lastName LIKE '%on';
    
    
    For example, to find all employees whose last names contain on , you use the following query with the pattern %on%

SELECT 
    employeeNumber, 
    lastName, 
    firstName
FROM
    employees
WHERE
    lastname LIKE '%on%';

Posted by: Guest on October-19-2020

Source

Code answers related to "mysql like clause"

Browse Popular Code Answers by Language

Answers for "mysql like clause"

Code answers related to "mysql like clause"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us