The LIKE operator is used for searching a specified pattern in the column. In this example we will show you how to use the Like operator to get the related results from the database.
Understand with Example
The Tutorial illustrates an example from LIKE Operator. In this example, The create table statement helps you to create a table 'Stu_Table'. Insert a records or rows into a table using insert into statement. Once your records is added into table, The records from a table can be retrieved by select statement in SQL.
Create Table Stu_Table
Insert data into Stu_Table
SQL LIKE Syntax
SQL Like Operator Query
Now we want to select the persons name those name starts with "k" from the table above.
Now we want to select the persons name those name ends with "h" from the table above.