MySQL partial SELECT?

[portnov]

Hello, i have small problem and wondered if anyone here knows,

Lets say i have field with array sized 100 and i want to get only the first 50 chars, can it be done on MySQL level? or i have to get entire data field and then removing the last 50 chars?

[Shuja Ali]

If I understand your question properly then you can use SubString method in your select query like this Select SubString(FIELDNAME,1,50) From TABLENAME

[portnov]

Thank you so much, thats what i was looking for.