Scribd Logo
Upload

Welcome to Scribd!

  • 34 views

    Select From Where Like: Customers City

    Uploaded by

    Ayoub Bokhabrine
    The document discusses SQL LIKE operators that can be used to match patterns in data. It provides examples of using % to match multiple characters, _ to match a single character, [charlist] to define sets of characters to match, and [^charlist] or [!charlist] to define sets of characters NOT to match. Examples are given showing how these operators can be used in a SQL WHERE clause to filter records by partial city names.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Select From Where Like: Customers City

    Uploaded by

    Ayoub Bokhabrine
    34 views2 pages
    The document discusses SQL LIKE operators that can be used to match patterns in data. It provides examples of using % to match multiple characters, _ to match a single character, [charlist] to define sets of characters to match, and [^charlist] or [!charlist] to define sets of characters NOT to match. Examples are given showing how these operators can be used in a SQL WHERE clause to filter records by partial city names.

    Original Description:

    document for math pif1005

    Original Title

    New Microsoft Word Document (8) (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses SQL LIKE operators that can be used to match patterns in data. It provides examples of using % to match multiple characters, _ to match a single character, [charlist] to define sets of characters to match, and [^charlist] or [!charlist] to define sets of characters NOT to match. Examples are given showing how these operators can be used in a SQL WHERE clause to filter records by partial city names.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    34 views2 pages

    Select From Where Like: Customers City

    Uploaded by

    Ayoub Bokhabrine
    The document discusses SQL LIKE operators that can be used to match patterns in data. It provides examples of using % to match multiple characters, _ to match a single character, [charlist] to define sets of characters to match, and [^charlist] or [!charlist] to define sets of characters NOT to match. Examples are given showing how these operators can be used in a SQL WHERE clause to filter records by partial city names.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

     % - The percent sign represents zero, one, or multiple characters

    The following SQL statement selects all customers with a City starting
    with "ber":

    SELECT * FROM Customers


    WHERE City LIKE 'ber%';

     _ - The underscore represents a single character

    The following SQL statement selects all customers with a City starting
    with any character, followed by "erlin":

    SELECT * FROM Customers


    WHERE City LIKE '_erlin';

     [charlist] - Defines sets and ranges of characters to match

    The following SQL statement selects all customers with a City starting
    with "L", followed by any character, followed by "n", followed by any
    character, followed by "on":

    SELECT * FROM Customers


    WHERE City LIKE 'L_n_on';

     [^charlist] or [!charlist] - Defines sets and ranges of characters NOT to


    match

    The following SQL statement selects all customers with a City starting
    with "b", "s", or "p":

    SELECT * FROM Customers


    WHERE City LIKE '[bsp]%';
    The following SQL statement selects all customers with a City starting with "a",
    "b", or "c":

    SELECT * FROM Customers


    WHERE City LIKE '[a-c]%';

    The two following SQL statements select all customers with a City NOT starting
    with "b", "s", or "p":

    SELECT * FROM Customers


    WHERE City LIKE '[!bsp]%';
    OR

    SELECT * FROM Customers


    WHERE City NOT LIKE '[bsp]%';

    You might also like