LIKE Search Pattern : Like « Regular Expression « SQL / MySQL






  1. SQL / MySQL
  2. Regular Expression
  3. Like

LIKE Search Pattern

       

_          Placeholder for an arbitrary character.
%          Placeholder for arbitrarily many (including 0) characters (but not for NULL).
\_         The underscore character _.
\%         The percent sign %.








Related examples in the same category

1.Where clause: like and %
2.To get the equivalent with LIKE, you'd have had to use % wildcards at the end:
3.like B%
4.like %r
5.LIKE '%e_'
6.Like and concat
7.Like and escape
8.LIKE '%is%'
9.LIKE '______' (underscore)
10.LIKE '______%' (underscore and %)
11.LIKE '_r%r_'
12.LIKE '_@%%@%_' ESCAPE '@'
13.To reverse the sense of a pattern match, use NOT LIKE.
14.SQL patterns do not match NULL values. This is true both for LIKE and NOT LIKE
15.Controlling Case Sensitivity in Pattern Matching. By default, LIKE is not case sensitive:
16.Pattern Matching: LIKE and %