[Solved] Batch Change Field Contents?

[kabing]

I discovered the other day that I need to change all the records with a country field entry of "USA" to "US". It seems to me that I've seen a way to do that with the SQL tool, but searching the forums hasn't turned up the post I thought I remembered. Is there a way to do this...aside from changing each record by hand, that is.

Thanks,

Kabing

[newuser]

I don't use HSQLDB but the command should be something like:

Code: Select all

UPDATE mytable SET fieldname = "US" WHERE fieldname = "USA"

[Villeroy]

Code: Select all

UPDATE "mytable" SET "fieldname" = 'US' WHERE "fieldname" = 'USA'

Single quotes denote literal strings, double quotes denote database names.

[kabing]

Thanks so much! It worked perfectly!

kabing