From: Dan Nelson
Date: July 20 2004 5:51am
Subject: Re: empty_blob() equivalent
List-Archive: http://lists.mysql.com/mysql/169322
Message-Id: <20040720055109.GA52838@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 20), Jeyabalan Murugesan Sankarasubramanian said:
> Is there any equivalent of empty_blob() in mysql. Kindly guide us in
> this regard. Thanks in advance.

You didn't tell us what empty_blob() is supposed to do.  If
empty_blob() checks to see whether a blob is empty:

  SELECT .... WHERE myblob = '';

If empty_blob() zeroes out a blob:

  UPDATE ... SET myblob = '';

blobs are just large varchars, basically.

-- 
	Dan Nelson
	dnelson@stripped