use AND with LIKE in sql

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 "use AND with LIKE in sql"

Browse Popular Code Answers by Language

Answers for "use AND with LIKE in sql"

Code answers related to "use AND with LIKE in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us