Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sqldate Mysql Date like

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Date like

Advertisement
The Like Operator is used in pattern matching by comparison with character string .

Mysql Date like

     

The Like Operator is used in pattern matching by comparison with character string . To grasp and understand the example of Mysql Date like  ,we create a  table employee1 with field attribute and data type respectively.  The create table statement construct a table 'employee 1'. 

Query to create table:-

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

Output:-

Query to insert data:-

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

mysql> insert into employee1(Empid,Empname,date)values('01','Girish','2008-12-20');
Query OK, 1 row affected (0.02 sec)

mysql> insert into employee1(Empid,Empname,date)values('02','Komal','2008-12-21');
Query OK, 1 row affected (0.02 sec)

mysql> insert into employee1(Empid,Empname,date)values('03','vineet','2008-12-21');
Query OK, 1 row affected (0.03 sec)

mysql> insert into employee1(Empid,Empname,date)values('04','Amit','2008-12-20');
Query OK, 1 row affected (0.02 sec)

Query to view data from the table created:-

The select statement return you the records from table 'employee1' 

mysql> select * from employee1;

Output:-

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     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 |
+-------+---------+------------+
7 rows in set (0.00 sec)

Query to view data using date like:-

The given below Query return you the records from table employee1 where date like '2008-12-20'.The like pattern is used in pattern matching by comparing with your date value specified like '2008-12-20'.

mysql> select * from employee1 where date like '2008-12-20';

Output:-

+-------+----------+------------+
| Empid | Empname  | date       |
+-------+----------+------------+
|     2 | komal    | 2008-12-20 |
|     2 | komal    | 2008-12-20 |
|     3 | Mahendra | 2008-12-20 |
+-------+----------+------------+
3 rows in set (0.00 sec)
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 9, 2009

Related Tutorials

Discuss: Mysql Date like  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com