activerecord not like query

Question

I could not find an activerecord equivalent of "Not Like". I was able to find a where.not, but that will check if a string does not match a value, as so:

User.where.not(name: 'Gabe')

is the same as:

User.where('name != ?', 'Gabe')

I was looking for a NOT LIKE, where the value is not contained in the string. The equivalent sql query would look like as follows:

SELECT * FROM users WHERE name NOT LIKE '%Gabe%'

In ActiveRecord I can currently get away with the following:

User.where("name NOT LIKE ?", "%Gabe%")

But that leaves a lot to be desired. Any new additions to Rails 4 to facilitate this?

Answer 1

Well, you can do something like:

User.where.not("name LIKE ?", "%Gabe%")

Note: This is only available in Rails 4.