Not exaclty a php thingie but well ;) Sql: Select left(column, 20) as c from table. Or you can do it with “select substr(columnname, 0,20)“. See the mysql manual. Dunno which of the two is faster, but i think “left“ is. Majk ----- Original Message ----- From: oxygenet32@xxxxxxxxx <oxygenet32@xxxxxxxxx> To: php-general@xxxxxxxxxxxxx <php-general@xxxxxxxxxxxxx> Sent: Wed Dec 02 16:11:55 2009 Subject: Best way to read first 20 characters of a string? Hi everyone, I'm pulling data from a mysql database, but need only the first 20 characters of each string for a short description, what is the best method to just grab the first 20 characters from a string regardless of whether they are letters or numbers? Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
