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]

Reply via email to