Mysql Date Wildcard

Wildcard in Mysql is used to search a data in the database. The Wildcard is used to substitute a character while searching a value in the database.

Mysql Date Wildcard

Mysql Date Wildcard

     

Wildcard in Mysql is used to search a data in the database. The Wildcard is used to substitute a character while searching a value in the database.

Understand with Example

The Tutorial helps you to make an example Date Wildcard in Mysql. Before going for this example, we create a table 'employee1' with field attribute and data type respectively. 

Query to create table:-

 

 

 

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

Output:-

Query to insert data:-

For inserting record value, we use insert into statement that adds records or rows into 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:-

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 date from the table created using wildcard:-

The given below Query returns you the records or rows from the table 'employee1' in which date begins with 20.

mysql> select * from employee1 where date like '%20';

Output:-

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     1 | Girish  | 2008-12-20 |
|     4 | Amit    | 2008-12-20 |
+-------+---------+------------+
2 rows in set, 1 warning (0.00 sec)