About Me

I have decades of experience is software development using .Net Technologies, PHP and wordpress. I love coding and discovering new tech.

Tag: MySql

Code Improvement, Database Management, Uncategorised

How to Split a String in MySQL Using the SPLIT_STR Function. The Right Way!

Posted on June 27, 2024  - By Kaustav Halder - 0 Comments

When working with strings in MySQL, there may be times when you need to split a string into individual components based on a delimiter. For example, you might have a comma-separated list of values and need to extract a specific...

Database Management

De-Dupe Your Database: Mastering MySQL’s Tools for Duplicate Removal

Posted on May 10, 2024  - By Kaustav Halder - 0 Comments

Welcome, fellow data enthusiasts! Today, we’re going to tackle a common yet pesky problem that plagues many a database: duplicate records. Fear not, for I shall guide you through the process of removing these unwelcome guests from your MySQL tables...