Changing multiple records simultaneously

Forum|Forum|16 years ago
March 19, 2009
2 replies
342 views

Is there a way of quickly changing the value of a field for multiple records in a batch?

I want to change the value of a field for all records from Y to N.

Eirther using SQL / phpMyAdmin, or some other way via DW?

Cheers.

Server side applications

This topic has been closed for replies.

N

Newsgroup_User

Inspiring

Iain71 wrote:
> I want to change the value of a field for all records from Y to N.

UPDATE myTable
SET fieldName = 'N'
WHERE fieldName = 'Y'

--
David Powers
Adobe Community Expert, Dreamweaver
http://foundationphp.com

DwFAQ

Participating Frequently

Update record server behavior

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded