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
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail: [EMAIL PROTECTED]
Uw bedrijf voor Multimedia op Maat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]