Spring Data mongodb like query

Question

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

Mehedi Hasan Shifat · Accepted Answer · 2022-07-01 07:45:55Z

2

Here is the raw mongo query for your sql :

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

or

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

answered Jul 1, 2022 at 7:45

Mehedi Hasan Shifat

7409 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

khoa junior · Accepted Answer · 2022-06-28 14:57:02Z

0

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

answered Jun 28, 2022 at 14:57

khoa junior

293 bronze badges

Collectives™ on Stack Overflow

Spring Data mongodb like query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related