# \[ANN\] ActiveRecord English Like Queries v0.0.2

**URL:** <https://www.ruby-forum.com/t/ann-activerecord-english-like-queries-v0-0-2/146228>\
**Category:** Rails\
**Created:** [August 19, 2008, 9:13am UTC](https://www.ruby-forum.com/t/ann-activerecord-english-like-queries-v0-0-2/146228 "2008-08-19T09:13:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [August 19, 2008, 9:13am UTC](https://www.ruby-forum.com/t/ann-activerecord-english-like-queries-v0-0-2/146228/1 "2008-08-19T09:13:17Z")

</div>

I am pleased to announce the release of the plugin English Like Queries  
[pronounced in a proper British accent] v0.0.2

Changes:  
klass.where ‘name includes’ =\> [‘abc’, ‘def’] now defaults to a .find  
:all query–much nicer.

English Like Queries:

Typically AR basically stinks to type in–it is way too wordy, and, for  
lack of a better term, SQL like.  
klass.find :all, :conditions =\> [“name LIKE ‘%?’”, ‘fred’]

This library condenses that to be a little more englishy, by allowing  
hashed parameters that are parsed for meaning, ex:

klass.where ‘name starts with’ =\> ‘fred’

This reads better, is much faster, has support for regex, case  
sensitivity, etc. without the pain of SQL.  
Currently as a rails plugin.  
Check it out.

[http://code.google.com/p/ruby-roger-useful-functions/wiki/EnglishLikeQueries](http://code.google.com/p/ruby-roger-useful-functions/wiki/EnglishLikeQueries)

-=R