title: How to get elasticsearch to perform similar to SQL 'LIKE'
body: <p>If using a SQL 'Like' statement to query data it will return data even if its only partially matched.  For instance, if I'm searching for food and there's an item in my db called "raisins" when using SQL the query would return "raisins" even if my search only contained "rai".  In elasticsearch, the query won't return a record unless the entire name (in this case "raisins") is specified.  How can I get elasticsearch to behave similar to the SQL statement.  I'm using Rails 3.1.1 and PostgreSQL. Thanks!</p>