> # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500: > > CREATE TABLE extraFieldOptions ( > > fieldID tinyint(3) unsigned NOT NULL default '0', > > fieldOption varchar(16) NOT NULL default '', > > fieldValue varchar(16) NOT NULL default '', > > PRIMARY KEY (fieldID,fieldOption) > > ) TYPE=MyISAM; > > > mysql> update extraFieldOptions set fieldValue = 'horizontal' where fieldID > > > = '2' and fieldOption = 'alignment'; > > Query OK, 0 rows affected (0.00 sec) > > Rows matched: 1 Changed: 0 Warnings: 0 > > > > MySQL doesn't produce an error.. but I think maybe it's the 'and' in > > my where clause that isn't working. I have looked high and low for an > > example of such a query but cannot find anything. Any help would be > > greatly appreciated. Thanks. > > what was the value of fieldValue prior to the update?
fieldValue is "vertical" before the update. -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
