Hello! I've been using MySQL version 3.22.32 and query with AND NOT phrase worked fine. Now I have MySQL version 3.23.36 and the same query is losing records. (the same data). The query is quite complicated: SELECT * FROM docs LEFT OUTER JOIN typy ON docs.nr = typy.nr LEFT OUTER JOIN kategorie ON docs.skrot=kategorie.skrot WHERE ( ( kword_1 LIKE '%pielgrzymka%' OR kword_2 LIKE '%pielgrzymka%') AND NOT ( kword_1 LIKE '%Ukraina%' OR kword_2 LIKE '%Ukraina%' ) ) ORDER BY nr_dokumentu DESC ON MySQL version 3.22.32 I have about 1000 records and on MySQL version 3.23.36 I have only two! Where are they? -- Pozdrawiam! Agnieszka Kądziołka - <[EMAIL PROTECTED]> Linkor - Systemy Informatyczne - <http://www.linkor.com.pl> Gliwice, ul. Plebiscytowa 1/327, tel. 231-92-31 wew. 353 --------------------------------------------------------------------- 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
