|Is there any way to access the match text in MySQL rlike selects?|
Hi. I am doing a select like this in MySQL 5:
select * from foo where bar rlike '(.*),(.*)';
The specific example here is made up. Anyway, I'd like to be able to get to the matched text from bar, like I can with various languages regexp libraries. Is this functionality exposed at all in MySQL? I've looked at the docs and can't see any indication that it is, so this might just be wishful thinking.
Tags for this post: mysql regexp rlike select
Related posts: MySQL User Camp 2006; MythBuntu 8.10 just made me sad; I won a radio shark and headphones!; My first sighting of the ImageMagick book in the wild; Thoughts on the first day of the MySQL user's conference; MySQL Tech Talks
posted at: 08:17 | path: /mysql | permanent link to this entry