MYSQL and UNIX timestamps...

[eluser]mddd[/eluser]
With LIKE, you are treating the date as a string and comparing against that. So Mysql will compare '1264163400' with '2010-01' and that will not match.
Assuming the database has to stay the same (so you will keep using Unix timestamps) I would do this:

Code:

SELECT * FROM events WHERE YEAR((FROM_UNIXTIME(date))=2010 AND MONTH(FROM_UNIXTIME(date))=1

So, you turn the number into a real date and then use Mysql's date functions to check that date.

But in my opinion it would be even better just to use a Date field (or Datetime if times are important). Then you would not have this issue. You can just as easily compare dates as timestamp integers. So why not use the smartness of Mysql for your date/time needs.