Changing multiple records simultaneously

[johngordon12]

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.

[DwFAQ]

Update record server behavior

[Newsgroup_User]

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