Re: REGEX help.

On Wednesday 29 May 2002 06:55, Kevin Stone wrote: > All I need to do is return anything matching the following pattern from a > specific column in a table. This is how I'd write it in PHP if I were > pulling the data from string. The string in this example is a direct copy > of one of the column fields.. > > <? > $str = "teaspoon_3 legends_3 lore_3 einstein_3 recipes_2 cups_2 plaster_2 > paris_2"; > > // Search for einstein in the string and return the number associated with > that word. > preg_match_all("'einstein_(\d)'", $str, $matches); > ?> > > What would be the SQL equivilant? I hate to seek a hand out here.. but I'm > struggling with SQL REGEX and there just aren't as many good examples out > there as there are for PHP. The MySQL manual wasn't much help that's for > sure. :-\ It doesn't seem possible. The MySQL REGEXP only returns a 1 or 0 to indicate a match or no match. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* You can't cheat an honest man. Never give a sucker an even break or smarten up a chump. -- W.C. Fields */