Retrieving From a Blob
How do I get the data out of a blob in a MySQL table?
All it returns is [blob] when i do Select * from table
thanks
How do I get the data out of a blob in a MySQL table?
All it returns is [blob] when i do Select * from table
thanks
Busy posted this at 08:12 — 24th March 2002.
He has: 6,151 posts
Joined: May 2001
SELECT * FROM table WHERE
(name like "%blob%");
which would get all the blob's from the table db
nike_guy_man posted this at 17:02 — 24th March 2002.
They have: 840 posts
Joined: Sep 2000
I think you misunderstood my question
The column is a BLOB not varchar or text or int etc
When I did that, I got a syntax error, but I still dont think that's the way to do it...
mairving posted this at 19:24 — 24th March 2002.
They have: 2,256 posts
Joined: Feb 2001
What are you storing in the db? I am assuming images. I personally think that it is a waste of time to store an image in a database. Anyway, check out this article for more info.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
nike_guy_man posted this at 19:35 — 24th March 2002.
They have: 840 posts
Joined: Sep 2000
Nevermind I've fixed it
Busy posted this at 05:21 — 25th March 2002.
He has: 6,151 posts
Joined: May 2001
what did you do?
nike_guy_man posted this at 12:02 — 25th March 2002.
They have: 840 posts
Joined: Sep 2000
I didn't want a BLOB i wanted a TEXT column
Thanks anyways for your help
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.