Removing partial data from a string

I was looking at REPLACE() to do this, but I’m not sure. I have a field called exp_days that shows data like this:


+31 days
-102 days
-10 days
+25 days

And I’d like to remove every instance of ’ days’ including the space before it and keep the positive or neg number. Not sure how to search a string like that, perhaps using LIKE?

UPDATE daTable
   SET exp_days = REPLACE(exp_days,' days','')

Perfecto! Many thanks.