All right, so how would one set up a select where
rows 1 and 2 are text and row 3 is a blob
and for argument sake assume jpg for the moment.
You want to select a row based on the content (image) of the jpg?
Not possible unless you pass the whole blob into mysql so it can
retrieve the record which would be extremely slow and extremely
"expensive" in terms of cpu / memory.
As you probably saw in the cross-post to the php-general list, you're
much better off just storing the filename in the database and storing
the image itself on the filesystem. Then you can easily search for
images with filename 'logo.jpg'.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]