Spring data JPA doesn't accept regex query

Asked Feb 12 '23 at 05:51

Active Feb 12 '23 at 05:51

Viewed 23 times

I have this method that aims to return objects using regex and pagination

Page<JokeModel> searchAllByPhraseRegex(String phrase, Pageable pageable);

However, this would throw an exception Unsupported keyword REGEX (1): [MatchesRegex, Matches, Regex]

Spring Data JPA docs explicitly stated that Regex is supported:

Moreover, Intellij does give suggestions for completing the method:

asked Feb 12 '23 at 05:51

What database are you using? the exception thrown is that the database does not support regex operation – efire-net Feb 12 '23 at 06:24
Oh I'm using MySQL. I just found out that it uses REGEXP and not REGEX. – John Roice M. Aldeza Feb 12 '23 at 06:26
See: https://stackoverflow.com/a/44738213/12881733 – Bill Mair Feb 12 '23 at 18:49

0 Answers0