learning to understand compress function

[Steve Buehler]

	I am trying to figure something out about the compress function.  If I 
wanted to compress a field in a column/row and write it back to the table, 
how can I do this?  Is it possible to do it in one command? I tried:
update `conflicts` set `fname`=(SELECT compress(`fname`) FROM `conflicts` 
WHERE `conflict_id`='2') where `conflict_id`='2'

But that didn't work.  This question is more a learning thing that anything 
else.  I am not even sure what I would use the "compress" function 
for.  Maybe somebody can also give me an example of the uses for 
it......why it would be used.  Also, If I wanted to compress the `fname` 
field for every row in the database, how would that be done?

Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]