Page 1 of 1

phase record with like keyword

Posted: Wed Mar 15, 2006 7:40 am
by pallabmondal123
I have a table name news . In which
one of field is date.The value of date
is putted by using mktime() function.
now i want to phase out the record
whose year 2005.

Example:
--------
(news)

id head date
-- ---- -----
1 A1 1124809860
2 A2 1134809862
3 A3 1125809865


how it is possible with help of like keyword in sql and php.

Posted: Wed Mar 15, 2006 8:08 am
by anjanesh
Is your date field stored as TIMESTAMP ?
If so, then you can use the DATE_FORMAT.

Posted: Wed Mar 15, 2006 8:27 am
by feyd
LIKE is not useful for this.

viewtopic.php?t=45528