how to display blob data back to text

2003-03-19 Thread Karthikeyan Balasubramanian
Hi, I m using the following query SELECT id, subject, news, date_format(date, '%m/%d/%Y %h:%i %p') AS date, author, link FROM news ORDER BY id DESC LIMIT 5 heres my table structure CREATE TABLE news (

Re: how to display blob data back to text

2003-03-19 Thread Paul DuBois
At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote: Hi, I m using the following query SELECT id, subject, news, date_format(date, '%m/%d/%Y %h:%i %p') AS date, author, link FROM news ORDER BY id DESC LIMIT 5 heres my table structure CREATE

Re: how to display blob data back to text

2003-03-19 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul DuBois wrote: At 5:39 -0800 3/19/03, Karthikeyan Balasubramanian wrote: Hi, I m using the following query SELECT id, subject, news, date_format(date, '%m/%d/%Y %h:%i %p') AS date, author, link FROM news