mysql case sensitive query

MySQL queries are not case-sensitive by default. Following is a simple query that is looking for 'value'. However it will return 'VALUE', 'value', 'VaLuE', etc…

SELECT * FROM `table` WHERE `column` = 'value'

The good news is that if you need to make a case-sensitive query, it is very easy to do:

SELECT * FROM `table` WHERE BINARY `column` = 'value'

Select current ( day ,month , year ) records mysql from timestamp column

Get Todays Record From table

SELECT * 
  FROM table1

  WHERE DAY(FROM_UNIXTIME(timestampfield)) = DAY(CURDATE())

Get Current Month Records

SELECT * 
  FROM table1  WHERE MONTH(FROM_UNIXTIME(timestampfield)) = MONTH(CURDATE()) 

Get current year Records

SELECT * 
  FROM table1  WHERE YEAR(FROM_UNIXTIME(timestampfield)) = YEAR(CURDATE())  

Just change the table name and timestampfield name .....