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