phase record with like keyword
Posted: Wed Mar 15, 2006 7:40 am
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.
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.