Support Ukraine

Russia's war against Ukraine is real and raw.
Civilians are getting killed, families destroyed, homes wrecked.
Our hearts are with those who suffer.

Updating Amazon RDS SSL/TLS Certificates for Laravel application on CentOS

October 29, 2019October 31, 2019 Michael Ryvkin Web Development 2 Comments 12

On October 9 Amazon sent out email to all customers with Amazon RDS instances titled “Update Your Amazon RDS SSL/TLS Certificates by October 31, 2019”. However the title is a bit misleading because the actual deadline is March 5, 2020.

How to split and search in comma-separated string in MySQL

May 3, 2017May 23, 2018 Michael Ryvkin Database Administration 26 Comments 67

There could be times when you need to split comma-separated values in a string and get a value at certain position. Obviously this could be done with explode in PHP or split in Perl using server-side script but what if you need to do it directly in MySQL.