i don't think mysql has a way to sort results like that, however you can make php do the work with
natsort()
PHP Code:
<?
$array = array();
$result = mysql_query("select configname from configs");
while($row = mysql_fetch_assoc($result)) {
$array[] = $row['configname'];
}
natsort($array);
foreach($array as $each) {
echo $each . "<br />\n";
}
?>