Filter Data in the MySQL WHERE Clause With Less Than and Greater Than Comparisons

While equality and inequality filter conditions are very common, many times you wish to filter the FROM clause table rows based on values that are less than or greater than another value. MySQL (and SQL in general) supports the less than (<) and greater than (>) operators. Continue reading and see examples of each…

(more…)

The Best 7 Reasons To Choose Mysql For Organizing Your Web Database

There have arrived a number of frameworks in the market to organize web databases like PostgreSQL, MongoDB, Oracle, etc. But the most popular one among these is MySQL. Statista gave MySQL second place as the most famous database technology. Although there are several competitors competing against MySQL, the popularity that MySQL enjoys can’t be compared with anything else. It is competing with all other technologies very fiercely. A survey conducted by Datanyze a few days back found that 14.46% of the users in the market are using MySQL. On the other hand, the share of MongoDB is just a mere 4.13%.

(more…)

OpenLampTech issue #32 – Substack Repost

There is a whole lot of great PHP, MySQL, and LAMP-stack content in this week’s OpenLampTech newsletter. But, would you expect any less? Me neither. Enjoy this edition and share with others. Thank you for being a dedicated reader!

(more…)