RE: sql search

["Thompson-Jordan" <Thompson-Jordan@mindspring.com>]

mv_case=no (or cs=no)

Christopher Thompson


> -----Original Message-----
> From: owner-minivend-users@minivend.com
> [mailto:owner-minivend-users@minivend.com]On Behalf Of Andreas Kotowicz
> Sent: Saturday, July 17, 1999 9:05 AM
> To: minivend-users@minivend.com
> Subject: sql search
>
>
> ******    message to minivend-users from 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
> -
> To unsubscribe from the list, DO NOT REPLY to this message.
> Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>