2013/8/2 Noel Grandin <noelgran...@gmail.com>: > > On 2013-08-02 15:10, Cecil Westerhof wrote: >> >> 2013/8/2 Noel Grandin <noelgran...@gmail.com>: >>> >>> 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
