The LIKE operator allows you to compare values in a field to a string or a pattern and see if there is a match.
LIKE operator is used together with WHERE clause.
The syntax for the LIKE Operator is:
SELECT [COLUMN NAME] FROM [TABLE NAME]
WHERE[COLUMN ] LIKE [CONDITION]
EXAMPLE :
For Example, we like to call out information of the player that Player Name start with 'J' .
Table GameScores
PlayerName | Department | Scores |
Jason | IT | 3000 |
Irene | IT | 1500 |
Jane | Marketing | 1000 |
David | Marketing | 2500 |
Paul | HR | 2000 |
James | HR | 2000 |
SQL statement :
SELECT * FROM GameScores
WHERE PlayerName LIKE 'J%'
Result:
PlayerName | Department | Scores |
Jason | IT | 3000 |
Jane | Marketing | 1000 |
James | HR | 2000 |