Hi!
I have tested your test case of two SELECT's producing different
outputs depending on the table ordering.
Those two queries were a problem :
-:-
SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord like
'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND
o1.kilde_id=link.id;
+----------------+-----+
| titel | id |
+----------------+-----+
| Bethanias Unge | 404 |
+----------------+-----+
1 row in set (0.01 sec)
mysql> SELECT link.titel,link.id FROM ord as o1,ord AS o2, link WHERE o1.ord like
'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND
o1.kilde_id=link.id;
Empty set (0.01 sec)
-:-
I have tested it all with the latest MySQL version and both queries
produced the following result:
+----------------+-----+
| titel | id |
+----------------+-----+
| Bethanias Unge | 404 |
+----------------+-----+
So, this must have been some bug that was fixed meanwhile.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
