[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: Update Query Error
From:       Emery Fabrice <nzeyimana () yahoo ! com>
Date:       2003-04-29 8:27:03
[Download RAW message or body]

UPDATE doesn't take a FROM.

The correct string should be:
 UPDATE login_db SET notes_field=REPLACE(notes_field,'!','1') 
 WHERE notes_field like '%!%';


Thanks
Emery
--- Chris Barnes <chris.barnes@hotonline.com> wrote:
> 
> Hello, anybody know why this doesn't work ?
> 
> UPDATE login_db SET notes_field=REPLACE(notes_field,'!','1')  from
> login_db where notes_field like '%!%';
> 
> TIA
> 
> Chris
> 
> -- 
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:   
> http://lists.mysql.com/myodbc?unsub=nzeyimana@yahoo.com
> 


=====
NEFA Computing Services, Inc.
NZEYIMANA Emery Fabrice
Office: 511106
Mobile: 08517768
Fax: 1(530) 326-4868
B.P.: 5078 Kigali
RWANDA.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]