Not only do I share the weekly OpenLampTech newsletter, but I’m also publishing some articles outside of the publication, directly to my Substack page. I’m resharing the last 2 I’ve posted over on my Substack for any interested readers…
Discover premium articles, in-depth guides, instructional videos, and much more by joining the “MySQL Learning Tier” membership. You have access to exclusive content unpublished anywhere else with this membership. With new content being added regularly, continue learning MySQL at any level.

MySQL SHOW TABLES – Two Variations
This post is an excerpt from some premium content I am creating here on my blog for beginners wanting to learn MySQL.
Read the full substack article: MySQL SHOW TABLES – 2 Variations.
Related: MySQL Beginners Series — The SELECT statement.
MySQL ROW_NUMBER() with CASE Expression
This post is another one I had a lot of fun writing because I learned so much while putting it together.
I’m covering how to collapse multiple rows into a single row per distinct group. The ROW_NUMBER() window function is key here and is center stage in this article.
Read the full substack article: MySQL ROW_NUMBER() Window Function with CASE Expression.
OpenLampTech is the newsletter for PHP/MySQL developers. Get the best original and curated content delivered directly to your inbox each week for free. Help build a great community by signing up today.
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
More ways I can help
- Any of the Web Squadron Mastery Modules can help you with your online web entrepreneurial endeavor(s).
- Get a handle on Google Analytics with this course by the folks over at The Content Technologist.
- Need hosting for your next web application or WordPress site? I highly recommend Hostinger and use them to host my niche bass fishing site. The service is second to none.
- 🔒5 Truths I’ve Come To Realize As a Self-taught Developer
Disclosure: Some of this blog post’s services and product links are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Disclosure: Some of this blog post’s services and product links are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.
If you found value in this post, you can show your appreciation and buy me a coffee. It is my favorite drink!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.