MYSQL REGEXP question
| From: | Mike van Hoof | Date: | Mon, 08 Jan 2007 09:29:48 +0000 |
| Subject: | MYSQL REGEXP question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42902@lists.php.net to get a copy of this message | ||
Hello,
i am try to make a regular expression work, but keep getting an 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