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

Different actions for different parts of a string
<?php
function dosomething($string, $else = '') {
if (empty($else))
$string

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

weird problem
last time, i did post a topic concerning why my page sometime will load as blank page when using IE.

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

Best PHP Documentation generator
Hello guys!

I would like to hear from you what is the best PHP documentation generator. Perso

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

quotes changing
hi all

in my content

opening quotes " changes to “

close qu

array_count_values question?
ok i'm trying to create a top ten list from a database of listed favorite movies.

the followi

Perplexing problem showing a .jpg
Please disregard..........I figured it out

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place