How can we search a record from MySQL table having a date as a value in it?

It can be understood with the help of following example in which we are using the following data from the table named ‘detail_bday’ −

mysql> Select * from detail_bday;
+----+---------+------------+
| Sr | Name    | Birth_Date |
+----+---------+------------+
| 1  | Saurabh | 1990-05-12 |
| 2  | Raman   | 1993-06-11 |
| 3  | Gaurav  | 1984-01-17 |
| 4  | Rahul   | 1993-06-11 |
+----+---------+------------+
4 rows in set (0.00 sec)

Now, in the following two ways we can search records using the date −

mysql> Select * from detail_bday Where Birth_Date = '1993-06-11';
+----+-------+------------+
| Sr | Name  | Birth_Date |
+----+-------+------------+
| 2  | Raman | 1993-06-11 |
| 4  | Rahul | 1993-06-11 |
+----+-------+------------+
2 rows in set (0.00 sec)

mysql> Select * from detail_bday Where Date(Birth_Date) = '1993-06-11';
+----+-------+------------+
| Sr | Name  | Birth_Date |
+----+-------+------------+
| 2  | Raman | 1993-06-11 |
| 4  | Rahul | 1993-06-11 |
+----+-------+------------+
2 rows in set (0.00 sec)

Nitya Raut

Published on 19-Feb-2018 12:08:38

• Related Questions & Answers
• How to search a record by date in MySQL table?
• How can we fetch a particular row as output from a MySQL table?
• How can I return a record from a table nearest to a user-defined variables value in MySQL?
• How can you delete a record from a table using MySQL in Python?
• Present date as default value in a table
• How can we extract a substring from the value of a column in MySQL table?
• How can we remove a column from MySQL table?
• How can we delete a single row from a MySQL table?
• How can we find the index position of a string stored as a record in MySQL table’s column?
• How can we fetch one or more columns as output from a MySQL table?
• Can we select second largest record from a table without using LIMIT clause in MySQL?
• How can MySQL interpret the number and string, having no delimiter, as a date?
• How can we drop UNIQUE constraint from a MySQL table?
• How can we delete multiple rows from a MySQL table?
• How can we delete all rows from a MySQL table?