2013/8/2 Noel Grandin <[email protected]>: > > On 2013-08-02 15:10, Cecil Westerhof wrote: >> >> 2013/8/2 Noel Grandin <[email protected]>: >>> >>> 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. >> >> Works like a charm, thanks. >> >> I am now using: >> REGEXP ' [Ff]ish[ .,]' >> >> It can start at the beginning of the line and stop at the end. So I >> would like to use something like: >> REGEXP '[ ^][Ff]ish[ .,$]' >> >> But that does not work. Is what I want possible? >> >> And I properly should add some other characters like: ;, :, … But for >> the moment it is good enough. > > > You should just use '\b[Ff]is\b' because '\b' matches word boundaries.
Works like a charm. Thanks. -- Cecil Westerhof -- 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.
