Enquiry Email Form

MySQL Functions, Tips & Tricks

MySQL – SELECT Rows Where First Character Is Not A Letter

Here are two methods of SELECTING rows where the first character is not a letter. For example, if you have the following data: So let’s say you want to select…

MySQL Functions, Tips & Tricks

MySQL – INSERT SELECT Example

I’m quickly going to demonstrate how to INSERT rows from one table into another table. I’d just like to clarify, this isn’t the same as completely copying a table, because…

MySQL Functions, Tips & Tricks

MySQL- Remove Duplicate Rows

I’ve been working with meduim sized tables (2.1million rows) in MySQL lately. One particular table had a lot of duplicate rows, which I needed to filter out. I’m quickly going…

MySQL Functions, Tips & Tricks

MySQL- Counting The Total Occurances Of A Regular Expression In A Table Column

Ok, so here’s the scenerio- you have a table like this in your DB: The question is: How do you count how many images there are in the images column…

Learning & sharing

This section is dedicated to MySQL Functions, Tips & Tricks, for both our own uses and for others to learn from. Sharing is caring.

Please feel free to contribute to our blog posts; perhaps even teach us a few tricks of your own. We'd love to hear your thoughts.



X