# [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?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
