--- Rajesh Kumar <[EMAIL PROTECTED]> wrote:
> Arun karthikeyan wrote:
>
> > Hi thank you ......
> > My database is retrieve from another automation tool.
> > My question is ..
> > Every link field should have 1 c='some value'
> > I want to get that value...
> > But i dont kno the position of c=.
> > That field having only one 'c='
> > Can you give me a query....
>
> There's no query you can do for that. You will have to retrieve the
> entire link and run a preg_match() on that using PHP:
>
> $result = mysql_query('SELECT link FROM table_name');
>
> while ($row = mysql_fetch_assoc($result)) {
>
> $cvalue = preg_match('/c=../', $row['link']);
> $cvalue = $cvalue[0];
>
> }
>
> --
> Rajesh
There is the RLIKE clause which is similar to LIKE but uses regular
expressions. I'm not sure if it could be used but it could be interesting.
James Keeline
