Spring Data MongoDB : like query example

By mkyong | Updated: October 12, 2013

Viewed: 4,431 (+20 pv/w)

Tags: like query spring-data

In SQL, the ‘like’ query is looks like this :

select * from tags where tagName like '%apple%'

In MongoDB console, it looks like this :

db.tags.find({"tagName": /apple/})

In Spring data mongodb, it implements with Criteria or BasicQuery :

	String tagName = "apple";
	
	Query query = new Query();
	query.limit(10);		
	query.addCriteria(Criteria.where("tagName").regex(tagName));
	
	mongoOperation.find(query, Tags.class);

	String tagName = "apple";

	BasicQuery query = 
		new BasicQuery("{\"tagName\": {$regex : '" + tagName + "'} }");
	query.limit(10);
	
	mongoOperation.find(query, Tags.class);

References

1. SQL to MongoDB Mapping Chart
2. MongoDB $regex
3. Spring Data MongoDB : Query Document