The MySQL DATE() function is a built-in function you use to extract just the date portion from a DATE or DATETIME value. Learn how to use the DATE() function in this blog post…
(more…)Blog Posts
Python vs. PHP: Which is Better for Web Development?
In the digital world, web development has become one of the most in-demand skills. The biggest companies have already invested in developing their website to help boost business and brand identity. When first developing a website, you may be wondering which programming language to use.
(more…)Range-based Filtering With the BETWEEN Operator in MySQL
This post covers filtering in the WHERE clause conditional using the MySQL BETWEEN operator. Continue reading this excerpt of premium MySQL content I’m creating for anyone to learn how to use MySQL…
(more…)OpenLampTech issue #27 – Substack Repost
Welcome back to this week’s OpenLampTech newsletter issue. In addition to the great PHP/MySQL content, I’ve edited one of the sections so there is a new feel to the publication. Enjoy reading the content!
(more…)Determine All Calendar Days in a Month with MySQL
Watch this quick in-depth video short and learn how to find all the calendar days for a specific month using built-in MySQL date functions and recursive Common Table Expressions (CTEs). This is a repost of a free article over on my Kofi page as part of the “MySQL Learning Tier” membership…
(more…)