On Mar 17, 2009, at 8:14 AM, Andrea Galeazzi wrote: > I meant: > SELECT title FROM tracks > WHERE title >= :last_title AND > (title>:last_title OR id>:last_id) AND title LIKE %Mad% > ORDER BY title,id; > better than > SELECT title FROM tracks > WHERE title LIKE %Mad% AND > title >= :last_title AND > (title>:last_title OR id>:last_id) > ORDER BY title,id;
The order of terms in the WHERE clause does not matter. Both SQL statements should generate the same query. D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
