You’d have to use a trigger if you wished to make the db do this, or you could quite simply use which ever programming language you are using to check the data entered before it was sent off to the db and alter it before creating your query.
When selecting your data, provided that the news_title field is set to null if not specified, you can use the COALESCE function, which returns the first of its parameters which is not null.
SELECT COALESCE(news_title, news_date) AS title...