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…)Latest Blog Posts
OpenLampTech issue #39 – Substack Repost
Welcome back to another issue of OpenLampTech, your source for original and curated MySQL, PHP, and LAMP stack content. We have another packed issue this week. Thanks for reading!
(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 #38 – Substack Repost
We have another massive newsletter for you this week. And OpenLampTech is growing! Thank you for making it a success!
(more…)MySQL WHERE Clause Inequality Comparison Operators
Just as you want to filter the rows of data returned in a SELECT query with the equality comparison operator (=), you can also create a conditional filter to test if 2 values are not equal to one another. Learn more in the following article.
(more…)