LIKE

used with WHERE instead of equal sign

  • can use % to represent arbitrary values (of arbitrary length) preceding or succeeding in position in the string
  • can use _ to represent an arbitrary value of length 1

Round/concat

How to use concat?