Useful String Function – REPLACE in MySQL with examples.

MySQL has a number of available String Functions, allowing you to work with string data values in a multitude of ways. In this blog post, I explore and learn about the REPLACE function, used to replace specific sections of a string…

[If you like MySQL, you are in the right place!!! >>>]

Advertisements

Structuring candidate date values with the STR_TO_DATE function in MySQL – with examples.

I visit Stackoverflow from time to time, curious about problems and issues plaguing developers, similar to my own. More importantly, I am drawn to the answers provided by the community to those problems. Recently, I read a question I was not 100% sure of the solution myself. Trust me, this is the case more often than not (haha). Perfect! Another opportunity to learn something new and here I am, sharing it with y’all…

[Keep reading great MySQL blogging >>>]

Understanding WHERE clause execution in MySQL with Derived Tables.

As I continue to learn MySQL, revisiting the fundamentals is of course, beneficial. As a matter of fact, it is integral for me to solidify many basic concepts. Nevertheless, most tutorials and blog posts only cover syntax for the chosen database.

Knowing the correct syntax is a must. But, something often overlooked is the execution order of the clauses, forming the foundation for queries. Which in turn, are very much different from their processing order. In this blog post, I will explore one of several differences. Referencing aliased column names in the WHEREclause…

[Interested in MySQL? Me too! You are in the right place!]