Thanks a lot!

I'm just blind!

"Quentin Bennett" <[EMAIL PROTECTED]> wrote in message
What's wrong with

select left(myfield, 500) from mytable;



-----Original Message-----
From: Micah Bushouse [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 17 December 2002 3:22 p.m.
Subject: [PHP] MySQL select a field's first X bytes

Is there a way in MySQL to select a fields first X bytes?

I have a field of type text.  I would like to print the first 500 or so
bytes of its contents as a summary of the entire field, then having the user
click "read more..." or something of that sort for the whole document.

I read up on select in the MySQL manual and didn't see much, does anyone out
there know of such a feature?  Should I just take the whole field into php
and do it that way?

Micah Bushouse

PHP General Mailing List (
To unsubscribe, visit:

The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If received in error you are asked to destroy this email
and contact the sender immediately. Your assistance is appreciated.

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to