got it, tnx anywayz
-- - Louie Miranda http://www.axishift.com ----- Original Message ----- From: "Louie Miranda" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 29, 2004 1:02 PM Subject: select some part, but excluding something. > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
