Extract string from a text after a keyword in sql?

I have the necessity to extract content from a text in a sql field after a keyword. For example if i have a field called description in a table, and the table content for that field is:
|Description|
asdasf keyword dog
aeee keyword cat
ffffaa keyword wolf
I want to extract and save the text after "keyword " (in this case dog,cat and wolf) and save it in a view or simply show it with a select. Thank you.