Hello!
Could somebody explain me why it's like that:
mysql> select count(*) from docs where kword_10 LIKE '%Ukraina%';
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.09 sec)
^^^ This is true!
mysql> select count(*) from docs where kword_10 NOT LIKE '%Ukraina%';
+----------+
| count(*) |
+----------+
| 2788 |
+----------+
1 row in set (0.08 sec)
mysql> select count(*) from docs;
+----------+
| count(*) |
+----------+
| 8001 |
+----------+
1 row in set (0.00 sec)
Wow?!?
I tried this on 3.23.36 & 3.22.30 and both returned different vaules in
second examle. Table docs is execkly the same on both MySQL's and kword_10
is a varchar(50). Please help me understand...
Cheers,
--
Jakub Wasielewski
<[EMAIL PROTECTED]>
---------------------------------------------------------------------
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