That would have to be:
db.users.find({"name": /.*m.*/})
Or, similar:
db.users.find({"name": /m/})
You’re looking for something that contains “m” somewhere (SQL’s ‘%
‘ operator is equivalent to regular expressions’ ‘.*
‘), not something that has “m” anchored to the beginning of the string.
Note: MongoDB uses regular expressions which are more powerful than “LIKE” in SQL. With regular expressions you can create any pattern that you imagine.
For more information on regular expressions, refer to Regular expressions (MDN).
Related Posts:
- Combining “LIKE” and “IN” for SQL Server
- How do you force mysql LIKE to be case sensitive?
- MySQL starts with searching issue
- List of special characters for SQL LIKE clause
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- Case in Select Statement
- What is SELF JOIN and when would you use it? [duplicate]
- Self Join to get employee manager name
- How do I UPDATE from a SELECT in SQL Server?
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- Online SQL Query Syntax Checker
- How can I do an UPDATE statement with JOIN in SQL Server?
- How do I use properly CASE..WHEN in MySQL
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- SQL SELECT WHERE field contains words
- Case statement in MySQL
- How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
- Drop a temporary table if it exists
- ORA-00918: column ambiguously defined in SELECT *
- IDENTITY_INSERT is set to OFF – How to turn it ON?
- How do I limit the number of rows returned by an Oracle query after ordering?
- MySQL: Invalid use of group function
- Why does NULL = NULL evaluate to false in SQL server
- Compare dates in MySQL
- Best way to do nested case statement logic in SQL Server
- Difference between one-to-many and many-to-one relationship
- Get day of week in SQL Server 2005/2008
- incorrect syntax error CREATE VIEW must be the only statement in the batch
- PLS-00103: Encountered the symbol when expecting one of the following:
- ORA-00918: column ambiguously defined in SELECT *
- How do I format date and time on ssrs report?
- How to parse XML data in SQL server table
- How do you create a temporary table in an Oracle database?
- Oracle SQL: Update a table with data from another table
- How to SUM and SUBTRACT using SQL?
- Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
- Postgresql tables exists, but getting “relation does not exist” when querying
- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
- SQL selecting rows by most recent date with two unique columns
- Postgres Error: More than one row returned by a subquery used as an expression
- Comparing Dates in Oracle SQL
- SQL Parentheses use in an OR clause
- Is it possible to GROUP BY multiple columns using MySQL?
- What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
- SQL “select where not in subquery” returns no results
- ListAGG in SQLSERVER
- SQL conditional SELECT
- The used SELECT statements have a different number of columns
- How can I search (case-insensitive) in a column using LIKE wildcard?
- ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
- using sql count in a case statement
- Oracle: If Table Exists
- Equivalent of explode() to work with strings in MySQL
- How to calculate age (in years) based on Date of Birth and getDate()
- How to create id with AUTO_INCREMENT on Oracle?
- Solutions for INSERT OR UPDATE on SQL Server
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- How can I group by date time column without taking time into consideration
- MySQL error: Unknown column in ‘where clause’
- What is the difference between Views and Materialized Views in Oracle?
- Append table to an existing one: SQL Server
- How to order by column A and then by column B?
- SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
- Update query using Subquery in Sql Server
- “This SqlTransaction has completed; it is no longer usable.”… configuration error?
- Use wpdb->prepare for `order by` column name
- register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
- prepare() not working
- How do I move a WordPress site to another server?
- Return number of items in a table with post id
- Cron While Editing Post
- Debugging WordPress
- Pull data and display as rows and columns
- find pods item where relationship to other pod is not set
- Export SQL query based on post type
- Convert a category of posts to a custom post type using (MySQL) queries
- I need a SQL command to delete specific authors and all posts connected with them
- Connect to Ms SQL Server
- How can i restore only Blogs from a SQL backup file?
- DB_HOST – is LOCALHOST speedy than domain name? [closed]
- wpdb prepare sql problem
- Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
- REGEXP_REPLACE in post_contet
- How to change post published date to today date with SQL
- Menu Order updating automatically
- Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
- How delete post_content records of specific category from phpmyadmin
- how to SELECT meta values that are not null?
- Fastest way to display 5000 post titles?
- How do I display SQL query on a specific page of my wordpress site
- Is it possible to utilize custom SQL for a single-post.php?
- How to handle my row actions on a custom list table in the admin section
- blank page after update my theme
- Sql query returns empty. But not
- How can I avoid duplicate primary keys in SQL import?
- SQL – JOIN last child
- Adding profile data to database
- How to get the sum of each post with the same date
- How to dump a Microsoft SQL Server database to a SQL script?
- Deleting the MySQL database