SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: Changing value's, query help.
-
Dec 2, 2008, 22:35 #1
- Join Date
- Jul 2006
- Posts
- 51
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Changing value's, query help.
I have a table i need to edit
i want to replace all values of 3 to 1 within a column.
eg. change blah to 3 where blah = 1
just not 100% sure on the right syntax.
hopefully someone can point me in the right direction.
-
Dec 2, 2008, 23:39 #2
- Join Date
- Jan 2004
- Location
- Luton, Beds
- Posts
- 1,791
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Code:UPDATE tablename SET blah = '3' WHERE blah = '1';
-
Dec 2, 2008, 23:46 #3
- Join Date
- Jul 2006
- Posts
- 51
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
thanks worked perfect.
-
Dec 3, 2008, 00:48 #4
- Join Date
- Jan 2004
- Location
- Luton, Beds
- Posts
- 1,791
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
extreme101,
My pleasure
.
Bookmarks