Learn SQL Like with 5 examples in 21 minutes

The Like operator of SQL

Following are the main points about the SQL Like operator:

  • The Like is an operator in SQL that is used to search columns data by the specified criteria.
  • The like operator uses the wildcard character(s) to search in a column.
  • The SQL wildcards are % (percentage) and _ (underscore).
  • The % is a wildcard that substitutes for zero or more characters whereas ‘_’ substitutes single character.
  • You can search text as well as numbers by using the Like SQL operator.
See Like with % example
Like with _ operator example

A Like Operator Short video