help with this query..

Question

$test2=mysql_query("SELECT min(substr(status,1) FROM railways");
while($test_array1=mysql_fetch_array($test2)){
echo "<pre>";
print_r($test_array1);
echo "</pre>"; 
}

what is the correct form of this query...need to get the min value from the table itself..

Answer 1

Hi Sachindra,

substr(status, 1) returns the string as it is ... mysql counts in strings from 1, not from 0.

if i got you right using substr(status,2) is what you are looking for.

best regards phil

Answer 2

substr(status, 1) is going to give 'w21', but substr(status, 2) is going to give 21. If you want to get the minimum and the pattern is DIGIT_NUMBER_NUMBER, you will use min(substr(status, 2)). From this data set: w21, c33, d55, d11, it will pull the minimum number you want.