updating a single value to multiple non consecutive rows

Posted on 16th Feb 2014 07:03 pm by admin

I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels.
I know I can update 1 with

SQL> update parcel
2 set expdate = sysdate
3 where prclid = 'A';

I imagin I need some thing like the following

SQL> update parcel
2 set expdate = sysdate
3 where prclid = 'A','C', 'D', 'G','E', 'J' ....

Your Answer:

Login to answer

Other forums

TinyMCE / Ajax Postback Problem
Hiya all,

I have a page which loads the TinyMCE editor. On the postback I obviously want to f

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

Production of mango in processing industry
Hi,

We have one scenario ,company is in process industry,they are manufacturing MANGO pul

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

ScriptManager History and Opera Issue
I am having an issue in opera with the ScriptManager. I have a ScriptManager on a page with history

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

help with mysql_error()
Hi,

I am trying to insert data into a table, but I am not able to insert it. I wanted to see

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W