Hi, I sorry for I neither didnīt find the information that I need in the documentation nor found the correct words for a search in the mailing archivers.
I have a query like this: SELECT cod, descr FROM table WHERE AND cod != 7 AND cod != 10 AND cod != 13 AND cod != 14 AND cod != 15 AND cod != 20 AND cod != 25 AND cod != 30 AND cod != 31 ORDER BY descr Is there a SQL command to make this query cleaner? I find something like: WHERE cod NOT IN (7,10,13,14,15,20,25,30,31) Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]