You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to-77-million.JPG' at line 1<br />select *,DATE_FORMAT(created_on,'%a, %D %b %Y %h:%i %p') as created_on2 from tbl_news where news_id=Gold-sold-90-million-to-77-million.JPG