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) |