Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • SQL LIKE Clause

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 279
    Comment on it

    The SQL like clause is used to look for the values which are similar to the values in the table with the help of wildcard operators. We have two types of wildcard operators:

    1. "% - percent sign

    2. _- underscore

    Syntax:
               SELECT FROM table-name
               WHERE column LIKE ' XX%';
                    or
               SELECT FROM table-name
               WHERE column LIKE '%XX%';
                     or
               SELECT FROM table-name
               WHERE column LIKE '_XX';
                     or
               SELECT FROM table-name
               WHERE column LIKE '_XX_';
    
    The only difference between these two wildcard operators is that former is used to represent 0,1 or multiple characters whereas the latter is used to represent a single number or character. Although, these symbols can be used in many different combinations:

    Query

    Description

    WHERE name LIKE 'A%'

    Look into the column name which starts with 'A'

    WHERE name LIKE '%N'

    Look into the column name which ends with 'N'

    WHERE name LIKE '%AN%'

    Look into the column name which contains the combination of 'AN' in middle.

    WHERE id LIKE '_00'

    Finds id that have 00 in the second and thord position.

    WHERE salary LIKE '2_%_%'

    Finds salary which starts with 2 and are alteast 3 characters in lenght.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: