Pseudo code:
open table “Master” for editing
If size = “24 x 12” then size_id = 153
How would I structure an SQL command to do this? Currently my MASTER table contains only a few thousand records, but it is still time consuming to manually each record with the updated info.
Hello,
Should be like:
Update "YOUR_TABLE_NAME" set "size_id" = 153 Where "size" = '24 x 12'
Always make a backup copy before running when dealing with possible large updates of this type.
Thank You!
@LSemmens, you can also give a big thank you to @Ratslinger by following the rules of this page:
If the answer from @Ratslinger has solved your problem, please click on the chekmark in the circle to the left of the answer and on the arrow ^ for a positive vote. This will tell the community that the question has been answered correctly, and @Ratslinger gets a bit of karma.
This automatically marks the question as resolved. Thank you!