[SOLVED] Strip Letters at End of Zip Codes

[TecTao]

I have a column of zip codes in an table.  they are the 9 number rather then simple 5 number such as 12345-6789

 

I have tried but can't seem to find a mysql command to strip all the characters from the - to get rid of the -6789, leaving only the 5 digit zip code.

 

Any help is appreciated, and thankyou in advance.

mike

[pocobueno1388]

The substr() function will give you what you want.

 

<?php

$zip = "12345-6789";
$zip = substr($zip, 0, 5);
echo $zip;

?>

[TecTao]

Thanks, that will work for a query, but what would be helpful is a sql command that will remove the last 5 from all of the entries in the table.  The table holds about 24,000 records and I want to update the zip column by deleting the last five characters.

[Psytherium]

UPDATE table

SET zip = LEFT(zip,5)