What is LIKE?

The LIKE function is used to search for patterns in text data.

How It Works

% -> Represents any number of characters (including zero).

_ → Represents a single character.

Syntax

SELECT column1, column2 FROM table_name WHERE column_name LIKE 'pattern';

an example finding all students who's In their 20's 

SELECT * FROM Students WHERE Age LIKE '2%';

Question number:

Up Next: Practice using AND

Donate

About

Privacy Policy

Changelog