[SOLVED] Easy Question : MySql Query

[hoopplaya4]

Here's an easy question (I think).

 

Is it possible, when doing a MySql Query to include a date() string?

 

For instance, if I'm doing:

 

SELECT * FROM table WHERE field LIKE 

 

Would it be possible to enter in something like "date(Y) after "LIKE?"  If so, what is the syntax?

 

Thanks!

[gaza165]

you can do something like....

 

$sql = "SELECT * FROM table WHERE MONTH(field) LIKE MONTH(date_field)"

[The Little Guy]

Something like so?

 

$mDate = date('Y');
$sql = mysql_query("SELECT * FROM table WHERE field LIKE '$mDate%'");
while($row = mysql_fetch_array($sql)){
     echo $row['field'].'<br />';
}

[flyhoney]

If you need to get really specific about dates you can use this approach:

<?php
$sql = "
SELECT
    COUNT(id) as total
FROM
    table
WHERE 
    date >= FROM_UNIXTIME(".mktime(0, 0, 0, date("m"), date("d"), date("Y")).")
";
?>

 

There might be a better way, but I've used this to find things like, "How many people registered this week?" or, "How many uploads have there been today?", etc...

[hoopplaya4]

Those are all great examples.  Thanks for the help.  I knew there was a way, I just needed to know how to go about doing it.  Take care.