REGEXP is just a pattern matching operator it will always return true or false. 
I guess you'll have to use ereg_replace() when using the results of your query. 

You also can try to use the MID function if the desired result has an absolute 
position within the string you're matching.

Hope this helps

Dobromir Velev
Web Developer

-----Original Message-----
From: Arash Dejkam <[EMAIL PROTECTED]>
Date: Friday, November 30, 2001 05:11
Subject: [PHP-DB] mysql and regular expressions

>SELECT "aaa45aaa" REGEXP "aaa(\d\d)aaa"   -> returns 1;
>is there any function in mysql to return "45" instead on 1 ?
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to