mysql and text

[daed17]

what is the best way using mysql to where I can limit the text displayed to so many characters?

Example:

mysql table has (1234,12345,123,123456)

and I want the output to be like (123,123,123,123)

can mysql do this?

[PunkSktBrdr01]

I don't think you can do this with MySQL, but it is easy with PHP. Check out the substr() (http://us2.php.net/manual/en/function.substr.php) function.