subject:"I need Query Help"

Re: I need Query Help

2006-02-10 Thread Gabriel PREDA

UPDATE `table1` SET `gender` = IF('f'=`gender`, 'm', 'f'); If you have NULL columns you might want to make another sublevel in IF to leave it NULL ! I believe this should do it... you might also take into consideraion removing the possibility of a NULL in the `gender` column... because it allows t

I need Query Help

2006-02-10 Thread Veerabhadrarao Narra

I have a table named table1 structure is ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | name | varchar(50) | NO | PRI | | | | gender | enum('f','m')