Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tech-notes:sql [2020/02/14 13:32]
gerardorourke
tech-notes:sql [2020/04/17 08:03] (current)
gerardorourke
Line 237: Line 237:
  
 </code> </code>
 +
 +===== Wildcards =====
 +
 +Reference: https://www.w3schools.com/sql/sql_wildcards.asp
 +
 +^ Symbol  ^ Description                                          ^ Example                                 ^
 +| %       | Represents zero or more characters                   | bl% finds bl, black, blue, and blob     |
 +| _       | Represents a single character                        | h_t finds hot, hat, and hit             |
 +| []      | Represents any single character within the brackets  | h[oa]t finds hot and hat, but not hit   |
 +| ^       | Represents any character not in the brackets         | h[^oa]t finds hit, but not hot and hat  |
 +| -       | Represents a range of characters                     | c[a-b]t finds cat and cbt               |