Spring Data mongodb like query

user_15993426 0
Viewed 78

I want to make a text search case insensitive with regex query with spring-data mongo .

For example in SQL:

SELECT * FROM Customers
WHERE CustomerName LIKE 'a%';

How can i make this query with spring-data mongo using MongoRepository Query DSL ?

Thanks in advance

spring-data-mongodb spring-boot mongodb repository
2 Answers

Here is the raw mongo query for your sql :

db.Customers.find( { CustomerName: /^a/ } )

or

db.Customers.find( { CustomerName: { $regex: /^a/ } } )

user_97848390 
public interface ProductRepository extends MongoRepository<Product, String> {

@Query("{$or : [{'name': { $regex: ?0, $options:'i' }}, {'description': { $regex: ?0, $options:'i' }}]}")
List<Product> findProductByRegexString(final String regexString);

you can use query like that hope help you

user_115719040
Related