Checking if a field contains a string

mongodb

You can do it with the following code.

db.users.findOne({"username" : {$regex : "son"}});

mongodb

As Mongo shell support regex, that's completely possible.

db.users.findOne({"username" : /.*son.*/});

If we want the query to be case-insensitive, we can use "i" option, like shown below:

db.users.findOne({"username" : /.*son.*/i});

mongodb

MySQL

SELECT * FROM users WHERE username LIKE "%Son%"

MongoDB

db.users.find({username:/Son/})

CodeHunter