Hello all,
Is there a mysql function that extracts sub matches from regular expressions. for example in perl when you match a string to a regular expression like /\s+(\S+)\s+(\S+)/ the submatches (strings matching the part of the expression between parenthesis) are available in variables $1, $2 etc. after the match. It would have been really useful if you could do that in sql. something like: select submatch(column,regular_expression) from table where condition etc. I couldn't find a mention of such function in the manual but I thought I'd ask. BTW, does any other DBMS implement such function. many thanks Murad Nayal --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php