List:General Discussion« Previous MessageNext Message »
From:Guenter Ladstaetter Date:July 15 2008 2:59pm
Subject:Update replace / Operand should contain 1 column(s) 1241
View as plain text  
Hello,

i'm trying to replace german umlauts by using a simple update replace statement
but can't find the syntax error:

UPDATE `phpbt_bug`
SET title = REPLACE (phpbt_bug.title,"ö","ö")
WHERE bug_id IN
(select bug_id, title from phpbt_bug where `title` LIKE "%ö%");


The error message is: Operand should contain 1 column(s) 1241


Thread
Update replace / Operand should contain 1 column(s) 1241Guenter Ladstaetter15 Jul
  • Re: Update replace / Operand should contain 1 column(s) 1241Rob Wultsch15 Jul