sql search

[Andreas Kotowicz <koto@mynetix.de>]

Hi all,


Does anyone know how to manage it that MV searches if I type "book" for all 
"book, BOOK, Book" or any other version of how book could have be written? 
I use Mysql and there you need to say exactly what you want "book or  BOOK 
or Book", but a "UPPER(category) LIKE '%BOOK%'" does look up any type of 
how book is spelled. So is there already a MV option I didn't find?


I hope anyone can help me.


Andreas Kotowicz