Here are the query results using Wild card Character.Consider below table
Student:
Now Consider the Query
Select * from student Where Name like ‘John%’.
It return results as name starts with john . You will get the result as
Select * from student Where Name like ‘%John’. It results as
Select * from student Where Name like ‘%John%’. It results as
Select * from student Where Class like ‘Fo_r’. '_' matches single character and replace it
