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, thei
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.