Hello,i am try to make a regular expression work, but keep getting this error message:
does anyone know how i can make it work? The query is: SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';So it has to match each starting 'b' and all the b's pf following words. But now followed by a v(line end) or a v followed by a space.
so it should match: 'b test' 'test b' 'test b bv' 'bv b test' and NOT 'test bv' 'bv test' Any idea's?! Thanks, mike