Ruby sql to trim an entire column in a model [duplicate]

Question

I have a location model with an attribute name. I want to trim(remove extra white spaces) the entire name attribute.

I tried to run

Location.TRIM(name)

But it isnt working. is the query wrong?

Why has this been marked as a duplicate of a question about stripping using Ruby, when this is clearly about the TRIM in sql? — user419017
– user419017, Commented May 18, 2016 at 12:19
@Ilya yes the question is about sql not string object. Could you remove the duplicate? In this case it update all the already saved Location in database with a sql method. — Guillaume
– Guillaume, Commented Jul 18, 2016 at 10:15

user419017 · Accepted Answer · 2016-05-18 09:33:14Z

6

This is what you are looking for:

Location.update_all('name = TRIM(name)')

answered May 18, 2016 at 9:33

user419017

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks .. It worked! :)