Hello,
I was working on a table, doing a simple update on
table. Query is:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS =
CASE WHEN REVIEWCOMMENTS='WHO2' THEN ''
WHEN REVIEWCOMMENTS LIKE '%,WHO2' THEN TRIM(TRAILING
',WHO2' FROM REVIEWCOMMENTS)
WHEN REVIEWCOMMENTS LIKE 'WHO2,%' THEN TRIM(LEADING
'WHO2,' FROM REVIEWCOMMENTS)
ELSE
REPLACE(REVIEWCOMMENTS, 'WHO2,', '')
END
WHERE QID IN
(3029,3041,3053,3076,3120,3121,3128,3133,3134);
It runs well, shows how many rows was affected. Then I
did query to pull out all updated records:
select qid, qd5,q1, reviewcomments
from temp
where qid IN
(3029,3041,3053,3076,3120,3121,3128,3133,3134)
order by qid asc;
There is no records return. The table is empty.
This happened second time. So I’m wondering it might
have some problem with my query.
Thanks a lot
Monet
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
