Thread: Need SQL command help...
View Single Post
Old 01-28-2006, 05:49 PM  
swedguy
Confirmed User
 
Industry Role:
Join Date: Jan 2002
Posts: 7,981
UPDATE tablename SET columnname=1 WHERE columnname=0

incase you have other numbers than 0 and 1 in that column
swedguy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote