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.


----- Original Message -----
From: <>
To: <>
Sent: Wed Dec 02 16:11:55 2009
Subject: [PHP] 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?


PHP General Mailing List (
To unsubscribe, visit:

Reply via email to