Techniquices

From https://github.com/bruderstein/nppPluginManager/issues/86 Notepad++ Plugin Manager refusing to download updates Description of the Issue Plugin manager refuses to download plugin list or updates. (...) Solution Guys thank you so much for your help. Especially the hint on the fact that plugin-manager is using IE components! My workplace IE settings seemed to be messed up. Was not able to access github.com (via IE) at all. IE actually tells you what to to: "Make sure TLS and SSL protocols are enabled. Go to Tools > Internet Options > Advanced > Settings > Security" Only TLS 1.0 and 1.1 have been enabled for me  🎉

From  https://coderwall.com/p/zzgo-w/splitting-strings-with-mysql Splitting Strings with MySQL MYSQL   SQL Sometimes when you're writing SQL queries you may need to split a string on a certain delimiter. For instance, if you want to break up a multi-line address into individual columns. If you were doing this in PHP it would be very easy. You simply gather your returned results, and use  explode  to split the string. Unfortunately, there is not a "split" function that does this in MySQL, but it can be achieved with the clever use of a different string function. Let's continue with the example of a multi-line address. Here is our address table: CREATE TABLE `address` ( `id` INTEGER AUTO_INCREMENT PRIMARY KEY , `fullname` VARCHAR ( 255 ), `company` VARCHAR ( 255 ), `street` VARCHAR ( 255 ), `city` VARCHAR ( 255 ), `state` VARCHAR ( 255 ), `zip` VARCHAR ( 20 ), `country` VARCHAR ( 255 ) ); And here is the