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. Quote Link to comment 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) Quote Link to comment Share on other sites More sharing options...
d_barszczak Posted June 24, 2008 Author Share Posted June 24, 2008 Thank you PFMaBiSmAd. 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.