select product_code,title,language,issue,category,cost from iip_t_cp where language = 'english';
I do this when selecting my database tables. But i would like to exclude one table "depleted" i have not included it on the select option but it is listed under language. Here are the tables mysql> desc iip_t_cp; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | product_code | varchar(255) | | PRI | | | | title | varchar(255) | | | | | | language | varchar(255) | | | | | | issue | varchar(255) | | | | | | category | varchar(255) | | | | | | cost | varchar(255) | | | | | | depleted | varchar(255) | | | 0 | | +--------------+--------------+------+-----+---------+-------+ 7 rows in set (0.00 sec) How can i do that? -- - Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
