How to Access MySQL at Web Hosts Without phpMyAdmin

While most web hosts have phpMyAdmin installed for their customers to use, there are plenty out there that do not. The phpMyAdmin interface is what most developers have become accustomed to when developing MySQL based websites. If phpMyAdmin is not installed on your web host, there are several options that will allow you to access [...]


Using MySQL in and between Clauses

In and between are two functions MySQL offers that aren’t something I use on a daily basis but they are incredibly useful from time to time for specific operations. The in() function can be IN() or NOT IN() and the same is applicable for BETWEEN or NOT BETWEEN.  Here some example queries of this functionality [...]