• HOME
  • Nginx
  • OS X
  • MySQL
  • Apache
  • WordPress
  • PHP
  • AWS
  • General
  • Archive
Home / Posts tagged SQL

Update specific posts with rel=”nofollow”

Posted on January 24, 2014 by Marko Tomic in WordPress with 0 Comments
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 […]

Read More

MySQL REPLACE statement with dynamic variables

Posted on September 10, 2011 by Marko Tomic in MySQL with 0 Comments

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 = […]

Read More

Tags

Apache AS3 aws bash ColdFusion command difftool DVD Flash Flex general Handbreak HOWTO iPhone iTunes Jaber java Linux MySQL networking Nginx OS X Performance Tuning PHP Railo Red5 S3 shell SQL SSH SSL SVN systems architecture tar Terminal Tigase Tomcat Ubuntu utilities VirtueMart web development WordPress XMPP ZenCart zip

Archives