Re: MYSQL REGEXP help

2007-01-08 Thread ViSolve DB Team
Hi, Try with mysql > select 'oer bv' REGEXP '(^b|[[:blank:]])(!?v|$v)'; Thanks ViSolve DB Team - Original Message - From: "Mike van Hoof" <[EMAIL PROTECTED]> To: "mysql" Sent: Monday, January 08, 2007 5:40 PM Subject: Re: MYSQL REGEXP

Re: MYSQL REGEXP help

2007-01-08 Thread Mike van Hoof
7; is an Operator and ? is a wild character. Only wildcharacters should be follow the Operators. Try with. SELECT 'boer bv' REGEXP '[b|^b](!?[v$|v])'; Thanks ViSolve DB Team - Original Message - From: "Mike van Hoof" <[EMAIL PROTECTED]> To: "mys

Re: MYSQL REGEXP help

2007-01-08 Thread ViSolve DB Team
?[v$|v])'; Thanks ViSolve DB Team - Original Message - From: "Mike van Hoof" <[EMAIL PROTECTED]> To: "mysql" Sent: Monday, January 08, 2007 1:36 PM Subject: MYSQL REGEXP help Hello, i am try to make a regular expression work, but keep getting this error

MYSQL REGEXP help

2007-01-08 Thread Mike van Hoof
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

MYSQL REGEXP help

2007-01-08 Thread Mike van Hoof
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