How to List the Most-Voted Posts in a Year using SQL?
In this post, we learn how to use SQL list the most popular posts (according to the number of comments for each posts). This posts, we will get some …
Category: SQL
How to Get Popular Posts of the Year using SQL? (2015)
At the end of each year, as a blogger, you might be interested in knowing the list of top popular posts of the year. Luckily, this can be easily …
Duplicate a MySQL table – Copy Table / Duplicate Database / PHP Script
August 31, 2014
database, DevOps, PHP, php, programming languages, SQL, sql, tricks, web programming
15 Comments
Suppose if you want to copy a Table to another, this can be done in MySQL with two steps. The first one is to copy the table structure, and …
How to Match Word Boundary using SQL?
In SQL, sometimes, you want to search a string field that contains a keyword, but as a whole word. So for example, if you search for ‘word‘, you do …