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 |