How to write MySQL command

[rajesh2006]

i have table name login_master and one field in there is "date_of_event"
example value date_Of_Event Jun 7, 2006 3:31:10 AM

Jun 7, 2006 to Jun 11, 2006 (I don't need time),how to write MySQL command?

pls help me

with regards,
rajesh

[debasisdas]

You need to convert the date to proper format for the purpose.

[mwasif]

What is the datatype of date_of_event? It looks like your data is in string format, then you can use STR_TO_DATE() function. In case of datetime data type, you can use DATE_FORMAT().

[amitpatel66]

i have table name login_master and one field in there is "date_of_event"
example value date_Of_Event Jun 7, 2006 3:31:10 AM

Jun 7, 2006 to Jun 11, 2006 (I don't need time),how to write MySQL command?

pls help me

with regards,
rajesh

 
SELECT * FROM login_master WHERE DATE_FORMAT(date_of_event, '%M %e %Y')  BETWEEN DATE_FORMAT('June 7 2006','%M %e %Y') AND DATE_FORMAT('June 11 2006','%M %e %Y');
 
 

[scot]

$tourneylist=mysql_query("SELECT tid,name FROM tourneys ORDER by name");
while(list($tid,$name)=mysql_fetch_row($tourneylist)){
$tourneylistid.="<option value='$tid'>$name</option>\n";
}