Wildcards or Special Characters

Special characters are used in SQL to replace one or more characters in text. These special characters are used in the LIKE clause, which is employed in the WHERE command to search for patterns in columns. More about the LIKE formula can be found in the previous post.

Special characters:

  • % – represents zero or more characters
  • _ – represents exactly one character
  • [] – represents any single character entered inside the brackets
  • ^ – when entered inside brackets, represents any character other than those entered inside
  • - – when entered inside brackets, represents a range of characters

Remember that these characters can be combined in various ways to create different combinations.

Interesting article? Share further!

Leave A Comment