Selecting records where they contain data similar to the search criteria.

Could you please help with the correct syntax to return records where a column contains data similar to my query.

This is the SQL equivalent
Select * from x where Crops LIKE %value%

I have tried this
return('{Crops: {"$contains": "'+value+'"}}');
Thank you.
1 person has
this question
This topic is no longer open for comments or replies.