Hi, 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 http://www.websitepulse.com/ -----Original Message----- From: Arash Dejkam <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, November 30, 2001 05:11 Subject: [PHP-DB] mysql and regular expressions >Hi, > >SELECT "aaa45aaa" REGEXP "aaa(\d\d)aaa" -> returns 1; > >is there any function in mysql to return "45" instead on 1 ? > >Arash >http://www.dejkam.com > > > >-- >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]
