Can I use LIKE in an UPDATE statement when it is not in the WHERE clause? I only know what the attribute name will end with (may be prefixed).
Example: UPDATE table SET LIKE '%donut' = valueColumn1 WHERE condition1 = value1; Respectfully, Ligaya Turmelle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]