How to remove a specific sql value from a string?

Question

MySQL

There is a selection
SELECT * FROM `alias` WHERE `keyword` like '%.html'
How do I remove the ending '.html' from all rows in the keyword column

Answer 1

I did this
UPDATE `alias` SET `keyword` = REPLACE( `keyword` , '.html', '' ) WHERE `keyword` LIKE '%.html'

Answer 2

Use substr to strip off the last 5 characters.
Something likeupdate 'alias' set keyword=substr(keyword,0,-5)