ggeiger — 2013-01-02T17:02:43-05:00 — #1
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?
r937 — 2013-01-02T17:12:22-05:00 — #2
SET exp_days = REPLACE(exp_days,' days','')
ggeiger — 2013-01-02T17:20:22-05:00 — #3