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

Users and Groups with PHP Classes
Hi,

I have setup what I hope to be a good working User class. Now I want to introduce group m

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

quick basic question, hopefully not dumb
I don't know how to search for this, so forgive me if it's been covered...

I often see an exa

SELECT * FROM users WHERE Users are not in Blocked
How do I select all users from users table where there users_id is not stored in the block table

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

how to insert value
I am having file bookissueadd.php..... in which i am having tag

<td height="21&q

Mysql query, two times?
Hello to all,

I'm new to php coding and i like it alot. I need help with some noob stuff.

Help pulling in 'id' with "read more" link
I'm trying to create snippets of my articles in the cms I'm creating, and then have them redirect to

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

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing