It’s no secret that text or string data are one of the most common datatypes you will process. At times, only a specific portion of a string may be needed and this is the perfect use case for the SUBSTRING() character function…

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.

Recently, I published an article over on the OpenLampTech Substack publication page, MySQL SUBSTRING() Function – With Examples, where I cover syntax and examples of the function.

…

This 20th issue of the OpenLampTech newsletter marks 5 continuous months of weekly publishing. Thank you, the readers, for making it possible and continuing to read these newsletters. Once again, this week’s issue has plenty of PHP/MySQL content so enjoy the newsletter!

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.

This week’s OpenLampTech newsletter issue has plenty to read for everyone as I am loading these newsletters up! We are looking at articles covering:

…

I recently needed to add multiple columns to an existing table to store summary data calculations and wondered if I could do it in one MySQL ALTER TABLE statement. Turns out you can. And, it’s super simple. Convenient too. Continue reading and learn what I learned…

Image by Gerd Altmann from Pixabay 

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you …

I’ve once again published a massive issue of the OpenLampTech newsletter, the newsletter for PHP/MySQL developers. If you’re looking to learn more about PHP and MySQL, you’ve come to the right place…

Image by Clker-Free-Vector-Images from Pixabay

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 …

This blog post is an excerpt from premium MySQL Beginner content I am creating to help anyone learn how to use MySQL. Thank you for reading and please do provide feedback.

Image by Willi Heidelbach from Pixabay 

You may also be interested in the blog post, MySQL Beginners Series — The SELECT statement, which is a primer for this article.

Limit …

I am so pleased to announce that I have published my very first mini eBook, “10 MySQL Tips For Everyone”. Continue reading to find out what it’s about, and how to get your copy.

What is the 10 MySQL Tips For Everyone eBook about?

In this eBook, I share 10 useful tips for anyone working with the MySQL database. These tips are a mix of the relatively common, and a couple of my personal own that I have realized or discovered as I continue to learn MySQL.

Here are a couple of my favorites.

So you’re (hopefully) wondering how you can get your own free copy of “10 MySQL Tips For Everyone”.

Super easy…

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.

That’s it.

Get ready for another jam-packed full OpenLampTech newsletter issue this week. If you are a PHP/MySQL developer, this is the newsletter for you. Let’s see what this latest issue has in store…

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.

Just like always, we have some great curated and original content in this week’s issue:

• MySQL NULLs in the ORDER BY clause
• PHP complete login and authentication
• How to use PHP and MySQL
• MySQL Events
• Missing MySQL extension for WordPress
• Free MySQL ebook
…

If you are like me, you enjoy your newsletter reading time. If you are a PHP/MySQL developer or a blogging developer yourself, then this post is definitely for you. Continue reading for additional details…

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.

Image by Gerd Altmann from  …

Joining individual pieces of text data into a singular string is nothing new in the programming world and all languages support some form of concatenation. In MySQL, you can use the CONCAT() function. Let’s see how…

Image by Alejandro González from Pixabay 

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 …

Do you know what time it is? The time for your weekly PHP/MySQL content is here! Enjoy OpenLampTech issue #17. As always there is plenty to read in this latest issue…

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.

Image by Clker-Free-Vector-Images from  …