I have a large blob column with encrypted data and also i have other
non-blob columns.  I get results when i do the following

Note: ID = non blob column

Select ID from table
> i get records returned

when i select from a blob column for example:

select blobcolumn from table
> it hangs no results. I have to CTRL C to exit out.

when i do this 

select blobcolumn from table
where id = 3232

> i get returned records


There's about 1.3 million records in this table.

what is the problem. Can any one Help?

thanks

sql

query

Jason Hall.

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to