Re: Update statement with LIKE

2004-03-10 Thread Egor Egorov
"Ligaya Turmelle" <[EMAIL PROTECTED]> wrote: > 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; > Find column n

Update statement with LIKE

2004-03-09 Thread Ligaya Turmelle
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 lis