How to write sql query?

Question

to comparing date and month for selecting upcoming birthday list in the only current month using substring for fetching in the gridview......share me..who knows related queries please
https://www.sololearn.com/discuss/1390307/?ref=app

Answer 1

date, month means if date_column and month_column . If the column is enlisted as birthday as a whole, use date (birthday) and month (birthday)

Answer 2

mark first one as the answer

Answer 3

shene What do you mean

Answer 4

do you want to compare date and month of today with the date and month provided in the database for birthdays. And if both match return Happy birthday as a message?

Answer 5

do you want to show this message in java or in mysql or other language?

Answer 6

use this link to connect your asp.net to mysql
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-asp-roles.html

and query for mysql is
select date, month from database_name where date=date(curdate())&&month=month(curdate());
Edit : date, month means if date_column and month_column . If the column is enlisted as birthday as a whole, use date (birthday) and month (birthday)

Answer 7

Welcome

Answer 8

And mark my post as the answer

Answer 9

are you working in MySQL?

Answer 10

tysm 😣

Answer 11

👍

Answer 12

yes

Answer 13

yes

Answer 14

asp.net

Answer 15

i dont know

Answer 16

do you know any related queries ....?