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

PHP & Images [Resize, Crop, Save]
Hey! Well I have a little dilema, hoping I could find some guidance.

I have a CMS and on the

Struct/union and scope problem!
HI all , I have
Code: in header.h typedef struct Node Link; /* ---------

Empty text file when there is over XXXX lines of text.

define("RANDOM_FILE","/public_html/random.txt");
$randomEntry = "

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

Multiple Options for a Single Page
For this example I want to use the Handlers option which is under Fed Admin and all the related codi

Uploading Filetypes and placing them in seperate folders.
Hello,

first post , and asking for help im afraid. Very new to PHP, was making good progress

Problem in String replace program's output
Hi all,
I was trying to make a program which accepts a string and replaces it with another stri

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

Array to string conversion
Can anyone help me with this?

Notice: Array to string conversion in /home/..../index.php on l