From: Dan Nelson
Date: March 13 2007 2:10pm
Subject: Re: function based index
List-Archive: http://lists.mysql.com/mysql/205551
Message-Id: <20070313141022.GC2435@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Mar 13), Ananda Kumar said:
> Is it possible to create function based index in mysql as available
> in oracle. Please point me to any documentation on this.

Sorry; mysql doesn't have function-based indexes.  The closest you can
get in mysql is if you add another column and an UPDATE trigger that
populates it with the results of your function, then index that column. 

-- 
	Dan Nelson
	dnelson@stripped