Mysql Like Operator

Mysql Like Operator is used to compare a part of string using the % wild card character.

Understand with Example

The Tutorial illustrate an example from 'Mysql Like Operator'. This section of tutorial lists  records or rows from the table employee1 where  like column 'name' end with the character '%h'.

'%h' : The '%h'  return the records from table where string end with h character.

The create table helps you to create a table 'employee1' with required fieldname and datatype.

Query to Create Table named employee1:

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

Query to insert data into Table named employee1:

Now we insert the records into 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:

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 below Query is used to return the records from table 'employees' in which name end with character '%h'.

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

Output:-

+-------+--------+------------+
| Empid | Name   | DOB        |
+-------+--------+------------+
| 1     | Girish | 2008-12-20 |
+-------+--------+------------+
1 row in set (0.00 sec)

Related Tags for Mysql Like Operator:
sql,  mysql,  c,  string,  com,  sed,  char,  compare,  operator,  using,  opera,  character,  like,  cte,  to,  ld,  e,  il,  li,  use,  pe,  art,  in,  part,  m,  par,  tr,  ca,  tor,  s,  at,  rac,  my,  k,  is,  ha,  ar,  act,  str,  rt,  s,  s,  ri,  ring,  rd,  th,  st,  om,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: Mysql Like Operator  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):