Effectively, the IN statement creates a series of OR statements… so SELECT * FROM table WHERE column IN (1, 2, 3) Is effectively SELECT * FROM table WHERE column = 1 OR column = 2 OR column = 3 And sadly, that is the route you’ll have to take with your LIKE statements SELECT * … Read more
I’ve always solved this using lower: SELECT * FROM trees WHERE LOWER( trees.title ) LIKE ‘%elm%’
.Where(oh => oh.Hierarchy.Contains(“/12/”)) You can also use .StartsWith() or .EndsWith().
Use LOWER function to convert the strings to lower case before comparing. Try this: SELECT id FROM groups WHERE LOWER(name)=LOWER(‘Administrator’)
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 … Read more