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

PlayerNameDepartmentScores
JasonIT3000
IreneIT1500
JaneMarketing1000
DavidMarketing2500
PaulHR2000
JamesHR2000

SQL statement :

SELECT * FROM GameScores
WHERE
PlayerName LIKE 'J%'

Result:

PlayerNameDepartmentScores
JasonIT3000
JaneMarketing1000
JamesHR2000