Update replace / Operand should contain 1 column(s) 1241

[Guenter Ladstaetter]

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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]