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

Hi
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
+1
This topic is no longer open for comments or replies.