SQL++ - Pattern matching with LIKE

String matching can be accomplished using the LIKE operator in the WHERE clause.

The argument on the right hand side of the keyword LIKE is the pattern that the expression must match. In these patterns % is a wildcard that matches zero or more characters, and _ is a wildcard that matches exactly one character.

In the example on the right we look for people who have a yahoo.com email address.

Try changing LIKE to NOT LIKE.

To run this example, click the button in the top right corner of the code editor.

Code Editor

Output