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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to