Instead of "binary" it sould be better to use a "case conversion" flag with reverse function - NOT set by default. "Binary" doesn't make sence to me. As for LIKE I think most WHERE commands use it so it is obvious it should be there.
Makis > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 23, 2002 6:29 PM > To: savaidis; [EMAIL PROTECTED] > Subject: RE: Comments in Documentation > > > At 16:01 +0200 2/23/02, savaidis wrote: > >Also there is not LIKE at all at SELECT command on MySQL manual! > > http://www.mysql.com/doc/S/t/String_comparison_functions.html > http://www.mysql.com/doc/P/a/Pattern_matching.html > > >I found manual very-very amateur work. > >I was trying about half hour to use <WHERE FIELD1= "mpla-mpla%"> > > I'm surprised that if you wanted to use LIKE, that you didn't just > try it. > > >Also "binary" at field creation or WHERE should be ON by default. > > What would the syntax be for turning it off? > > > And WHERE > >works erroneously with Greek chars (without the "binary" > option). I think it > >is comfused by other languages chars so it should be an > option to declare > >the language character set at runtime (not at server cnf). > > > >Makis > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
