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:
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?
SET exp_days = REPLACE(exp_days,' days','')
This topic is now closed. New replies are no longer allowed.