rwachowiak Posted March 19, 2008 Share Posted March 19, 2008 i want to insert "WORD.jpg" into "Filetype" on my table for all rows that have "application/msword" as the field "Type" whats the best/easiest way to do so?! thanks! Quote Link to comment Share on other sites More sharing options...
trq Posted March 19, 2008 Share Posted March 19, 2008 UPDATE tbl SET FikleType = 'WORD.jpg' WHERE Type = 'application/msword' Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted March 19, 2008 Share Posted March 19, 2008 Run this query: UPDATE table_name SET Filetype='WORD.jpg' WHERE Type='application/msword' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.