Home Sql Sqldate Mysql Date like

Mysql Date like
Posted on: June 9, 2009 at 12:00 AM

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)

Related Tags for Mysql Date like:
sql, mysql, c, table, date, data, asp, type, field, attribute, create, tab, like, ie, example, with, to, exam, ld, e, it, li, pe, as, sta, m, tr, es, spec, em, xa, xamp, s, respect, sp, ee, esp, at, ras, my, k, iv, mpl, ea, and, tt, s, s, ri, th, st, ab, abl, grasp, ple, pl, nd, o

«Previous Index Next»