d_barszczak Posted June 23, 2008 Share Posted June 23, 2008 I have a column called `shortname` and i need to add a prefix to every entry of 'ths_'. Is there a way i can do this with one query without having to use php. Thanks. Link to comment https://forums.phpfreaks.com/topic/111452-solved-query-help/ Share on other sites More sharing options...
PFMaBiSmAd Posted June 23, 2008 Share Posted June 23, 2008 Of course - UPDATE tbl_name SET shortname=CONCAT('ths_',shortname) Link to comment https://forums.phpfreaks.com/topic/111452-solved-query-help/#findComment-572302 Share on other sites More sharing options...
d_barszczak Posted June 24, 2008 Author Share Posted June 24, 2008 Thank you PFMaBiSmAd. Link to comment https://forums.phpfreaks.com/topic/111452-solved-query-help/#findComment-573079 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.