将字符串数据类型与日期数据类型PHP MYSQL进行比较

Question

In my MySQL database, I have this Time data type as one of my values: 06:00:00. I have the following query that checks the time as one of the conditions that has to be satisfied

$time = "06:00:00";

$getdetails=SELECT First_Name, Last_Name, EMAIL 
FROM parents 
WHERE Email_Receive_Time = $time; 

$results=mysql_query($getdetails);

However I do not get any results. On further research I have seen that it is because I am comparing a STRING type value ($time) to a TIME type value (value in my database). Is there a way i can compare the two without changing my database structure to a varchar? All help will be appreciated.

Answer 1

MySQL is perfectly capable of comparing a string to a TIME value. You just need to have the proper query syntax. In your case, you need to quote the comparison value:

$time = "06:00:00";

$getdetails = "SELECT First_Name, Last_Name, EMAIL 
FROM parents 
WHERE Email_Receive_Time = '$time'"; 

$results=mysql_query($getdetails);

And if it is user-supplied, well you should escape it.