How do you do wildcard searches with Mongoid in a Ruby on Rails environment? How do you do wildcard searches with Mongoid in a Ruby on Rails environment? mongodb mongodb

How do you do wildcard searches with Mongoid in a Ruby on Rails environment?


You need this to find people with "na" in the name.

Person.where(first_name: /na/i)

As for your example:

Person.where(first_name: /^d/i)

^ means "beginning of the line". This regex will match all strings where first letter is "d". /i means "do case-insensitive matches". So it'll match both "d" and "D".

Note: only prefix regexes (with ^ in front) are able to use indexes.

Is there website or guide with this information?

Here's my favourite.


This is not a "wildcard" search, this is called a regular expression.

/^d/i
  • The two slashes are only the regex delimiters, you search for what is in between those two slashes.
  • The following i is a modifier or option. It changes the matching behaviour of your regex, the i stands for case insensitive, means it matches "d" and "D".
  • The first character ^ is an anchor, it anchors the search pattern to the start of the string, means match "d" only at the start of the string

A good tutorial about regular expressions is the tutorial on regular-expressions.info

If you want to search for a string anywhere in the string, just remove the anchor that binds the pattern to the start, /na/ will find "na" anywhere in the string.