SQL like wildcard description

Source: Internet
Author: User

_ Match with any single character
 
% Matches a string that contains one or more characters.
 
[] Matches any single character in a specific range (for example, [a-f]) or a specific set (for example, [abcdef.
 
[^] Matches any single character other than a specific range (for example, [^ a-f]) or a specific set (for example, [^ abcdef.
 

For more information about how to use the like character and add the SQL wildcard, see:
A. Like 'mc % 'searches all strings starting with MC (for example, mcbadden ).

B. Like '% Inger' searches all strings ending with the letter Inger (such as ringer,
Stringer ).

C. Like '% en %' searches for all strings containing letters en at any position (such as Bennet,
Green, mcbadden ).

D. Like '_ heryl' searches for names of all six letters ending with the letter heryl (for example, Cheryl,
Sheryl ).

E. Like '[Ck] ARS [EO] n' will search for the following strings: Carsen, Karsen, Carson, and karson
(Such as Carson ).

F. Like '[M-Z] Inger' will search for any single word ending with string Inger from m to Z
All names starting with the parent (such as ringer ).

G .. like'm [^ C] %' will search for all names starting with m, and the second letter is not C (such
Macfeather ).

Example:

? Where firstname like '_ im' can find names ending with IM (for example, Jim and Tim) with all three letters ).
 
? Where lastname like '% Stein' can be used to locate all employees whose names end with Stein.
 
? Where lastname like '% Stein %' can be used to locate all employees whose surnames include Stein.
 
? Where firstname like '[JT] Im' can find names with three letters ending with IM and starting with J or T (I .e., only Jim and Tim)
 
? Where lastname like'm [^ C] %' can find all the surnames starting with M and ending with (second) Letters not C.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.