生日报警器怎么弄呢?

Question

1.php+mysql
try:
<?php
$sql = "select ..... where right(birth_date,4)='".date("md");
?>
2.mysql
try
$sql = "select .... where birth_date=replace(right(curdate(),5),'-','')";

Answer 1

mistake
<?php
$sql = "select ..... where right(birth_date,4)='".date("md")."'";
?>

Answer 2

....
手快。不好意思
2.mysql
try
$sql = "select .... where right(birth_date,4)=replace(right(curdate(),5),'-','')";

Answer 3

我用了:
FROM_UNIXTIME( UNIX_TIMESTAMP(),'%m%d')=RIGHT(user_birthday,4)
大家评价评价

Answer 4

都可以的。用php进行筛选和使用MySQL进行筛选都是可以的