Mysql Like Command

Mysql Like Command is used for retrieving the records from a table on the basis of pattern matching. The comparison 'like' operator return you the record from a table on the basis of pattern matching with a character.

Understand with Example

The Tutorial illustrate an example from 'Mysql Like Command'. To grasp this example we create a table 'employee1'. The create table is used to create a table employee1 with required filedname and datatype respectively.

SYNTAX:-Select * from [tablename] where [columnname] like ['columnvalue'];

Query to Create Table named employee1:

mysql>CREATE TABLE employee1 (              
         ->    Empid int(10),         
         ->    Empname varchar(60),   
         ->    date date 
         ->  );

Query to insert data into Table named employee1:

The insert into add the records or rows to the table 'employee1'.

mysql>insert into employee1 values(01,'Girish','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(03,'vineet','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(04,'Amit','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Komal','2008-12-23');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'Sandeep','2008-12-24');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(02,'suman','2008-12-25');
Query OK, 1 row affected (0.02 sec)
mysql>insert into employee1 values(01,'AAA',' 2008-12-03');
Query OK, 1 row affected (0.02 sec)

Query to view data of Table named employee1:

To view the detail of records we use select query that return you the table employee1 records.

mysql> select * from employee1;
+-------+---------+------------+
| Empid | Name    | DOB        |
+-------+---------+------------+
| 1     | Girish  | 2008-12-20 |
| 2     | Komal   | 2008-12-21 |
| 3     | vineet  | 2008-12-21 |
| 4     | Amit    | 2008-12-20 |
| 2     | Komal   | 2008-12-23 |
| 2     | Sandeep | 2008-12-24 |
| 2     | suman   | 2008-12-25 |
| 1     | AAA     | 2008-12-03 |
+-------+---------+------------+
8 rows in set (0.00 sec)

Query to view data from Table named employee1 using like command:

The Query below is used to return the set of records from employee1in which name begin with' komal' . The like operator allows you to return the records from column name matching with 'komal' in the table employee1.

mysql> select * from employee1
    -> where name like 'komal';

Output:-

+-------+-------+------------+
| Empid | Name  | DOB        |
+-------+-------+------------+
| 2     | Komal | 2008-12-21 |
| 2     | Komal | 2008-12-23 |
+-------+-------+------------+
2 rows in set (0.00 sec)

Mysql Like Command

Mysql Like Command

Mysql Like Command

Tutorials