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
