On 2013-08-02 14:27, Cecil Westerhof wrote:
I had to search for an article containing fish. Just using LIKE
'%fish%' resulted in much to many. So I used '% fish %', but did not
find, what I knew existed. Turns out fish was at the end of he
sentence and I found it with '% fish%'.
Is there a way to search for whole words?
H2 supports REGEX which is similar to LIKE except that you can use the
full regular expression matching syntax.
See java.util.regex.Pattern for the syntax.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
