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! Link to comment https://forums.phpfreaks.com/topic/96951-insert-into-with-a-where/ 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' Link to comment https://forums.phpfreaks.com/topic/96951-insert-into-with-a-where/#findComment-496118 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' Link to comment https://forums.phpfreaks.com/topic/96951-insert-into-with-a-where/#findComment-496120 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.