regex - MongoDB Regular Expression: Contains an e-mail inside a string

Question

Given that I have a string such as

"Donald Trump <[email protected]>" 
"Art Job <[email protected]>"

How can I find every row that contains "[email protected]" using MongoDB in Rails?

Thanks

Answer 1

From the documentation:

search_string = params['search']

# Constructor syntax coll.find({"name" => Regexp.new(search_string)})

# Literal syntax coll.find({"name" => /#{search_string}/})

Beware though... You can't use an index with this query since your regex isn't anchored to the front of the string.