RegEx para extraer datos

[andresdzphp]

Supongo que algo así:

Código PHP:

<?php
$str = "INSERT INTO country VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');";
$str = str_replace(array("INSERT INTO country VALUES ('", "');"), array('', ''), $str);
$str = explode("','", $str);
echo $str[0] . '<br />';
echo $str[2];
 

o algo así:

Código PHP:

<?php 
$str = "INSERT INTO country VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');";
preg_match_all("@'(.*?)'@i", $str, $m);
echo $m[1][0] . '<br />';
echo $m[1][2];