[PHP] MySQL select a field's first X bytes

2002-12-16 Thread Micah Bushouse
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

RE: [PHP] MySQL select a field's first X bytes

2002-12-16 Thread Quentin Bennett
What's wrong with select left(myfield, 500) from mytable; ? Quentin -Original Message- From: Micah Bushouse [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 December 2002 3:22 p.m. To: [EMAIL PROTECTED] Subject: [PHP] MySQL select a field's first X bytes Is there a way in MySQL

Re: [PHP] MySQL select a field's first X bytes

2002-12-16 Thread Micah Bushouse
p.m. To: [EMAIL PROTECTED] 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