MongoDB query with Mongoose and Node.JS with a case and accents regex

Question

I'm trying to write a MongoDB query with Mongoose in Node.JS to get all names in a database matching a certain name. I would like that the query ignores the case and accents.

I looked around on the internet but couldn't find a query that does that.

MongoDB queries support regexes so that's what I'm trying to do.

This is what I have now. It works but doesn't match if the query or the queried string has accents and the other doesn't.

Passenger_record.find({$and: [{"FIRSTNAME": { $regex:req.query["firstname"], $options: 'i' }},{"LASTNAME": { $regex:req.query["lastname"], $options: 'i' }}]}).exec(function (err, person)

Thanks for your help.

Community · Accepted Answer · 2017-05-23 11:56:54Z

1

Check this out, Programatic Accent Reduction in JavaScript (aka text normalization or unaccenting)

You'll find a function to build an accent insensitive regexp.

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Jan 29, 2013 at 9:38

Guillaume B

262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB query with Mongoose and Node.JS with a case and accents regex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related