The LIKE operator allows you to compare values in a field to a string or a pattern and see if there is a match.
The syntax for the LIKE Operator is:
SELECT [COLUMN NAME] FROM [TABLE NAME]
For Example, we like to call out information of the player that Player Name start with 'J' .
SQL statement :
SELECT * FROM GameScores