MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mike van Hoof Date:January 8 2007 8:06am
Subject:MYSQL REGEXP help
View as plain text  

i am try to make a regular expression work, but keep getting this error 

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
mail: mike@stripped
Uw bedrijf voor Multimedia op Maat

MYSQL REGEXP helpMike van Hoof8 Jan
  • Re: MYSQL REGEXP helpViSolve DB Team8 Jan
    • Re: MYSQL REGEXP helpMike van Hoof8 Jan
  • Re: MYSQL REGEXP helpViSolve DB Team9 Jan