Hello!

Lattatok mar ilyet? Teljesen tanacstalan vagyok.

mysql> select count(*) from gps where (processed = '' or processed is 
null) and fix = 'A' order by dt asc;
+----------+
| count(*) |
+----------+
|    11098 |
+----------+
1 row in set (1.65 sec)

mysql> select count(*) from gps where (processed = '' or processed is 
null) and fix = 'A';
+----------+
| count(*) |
+----------+
|    11098 |
+----------+
1 row in set (1.33 sec)

mysql> select * from gps where (processed = '' or processed is null) and 
fix = 'A' order by dt asc;
Empty set (0.00 sec)

mysql> select * from gps where (processed = '' or processed is null) and 
fix = 'A';

...es akkor itt jon a result amit varok, csak nem dt szerint rendezve. 
Ez most igy hogy?
-- 
Hofferek Attila
_________________________________________________
linux lista      -      [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux

válasz