Blogger

How to create a Reusable Block in WordPress

I’m using Reusable Blocks a great deal on the Digital Owl’s Prose developer blog and my bass fishing niche website. Reusable Blocks are easy to create and use, but oh so powerful. I like ’em. A lot. Continue reading and learn how to create a WordPress Reusable Block. 👇

(more…)

MySQL WHERE Clause Equality Comparison Operator

We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…

(more…)

CodeIgniter 4 Query Builder join() Method Explained

The CodeIgniter 4 Query Builder class provides ORM-like functionality for Database operations in the framework. As developers, we know SQL JOINs are foundational and oftentimes required in order to retrieve the correct data. The Query Builder class has a dedicated join() method you can use when constructing queries where JOINs are necessary. Continue reading and learn how to use the CodeIgniter 4 Query Builder join() method…

(more…)

MySQL Count Weekday occurrences

Each SQL dialect is different in some way, shape, form, or fashion from the next flavor. Some dialects have this function, while others have that function. In this post, I cover porting over Oracle SQL to MySQL in order to count the number of occurrences of a specific weekday found in the current given month (at the time of writing) purely as a learning exercise focused on MySQL DATE functions and the WITH clause…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]

TRIM() string function in MySQL – with examples.

In this post, I’ll cover examples of the MySQL TRIM() function. TRIM() removes specific characters – or spaces – from a given string, at either: the beginning, ending, or potentially in both locations depending on several factors. With an optional keyword argument that controls which character(s) – if any – are removed, TRIM() can be tricky so let’s gain understanding with several easy-to-digest examples…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]