SQL Archives -

Home / Posts tagged SQL

Update specific posts with rel=”nofollow”

Occasionally, you may want to update specific posts to have all links attributed with rel=”nofollow”. For example, if you have sponsored posts on your site you may want them to have the rel=”nofollow” attribute so that google does not index those external links on your site. I client of mine asked me to do this […]

MySQL REPLACE statement with dynamic variables

I just wrote a little mysql snippet that will replace all instances of ‘domain1’ to ‘domain2’ in a given table and column. So why not share it. All you need to do is set the variable values in first 4 lines of code below: SET @tblname = "tablename"; SET @colname = "columnname"; SET @lookfor = […]