SELECT pub_date FROM book_info WHERE pub_date <>ROUND(pub_date,0)
UPDATE book_info
SET pub_date =0 WHERE (pub_date REGEXP ‘[^0-9.]’) =1
SELECT pub_date FROM book_info WHERE pub_date <>ROUND(pub_date,0)
UPDATE book_info
SET pub_date =0 WHERE (pub_date REGEXP ‘[^0-9.]’) =1