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
