Advanced Data Filtering
In this tutorial, you'll learn how to combine WHERE clauses to create powerful and sophisticated search conditions. You'll also learn how to use the NOT and IN operators.

Wildcard Filtering
In this tutorial, you'll learn what wildcards are, how they are used, and how to perform wildcard searches using the LIKE operator for sophisticated filtering of retrieved data.

Filtering Data
In this tutorial, you will learn how to use the SELECT statement's WHERE clause to specify search conditions.

Sorting Retrieved Data
In this tutorial, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.

Retrieving Data
In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.

Working with MySQL
In this tutorial, you'll learn how to connect and login to MySQL, how to issue MySQL statements, and how to obtain information about databases and table.

Searching Using Regular Expressions
In this tutorial, you'll learn how to use regular expressions within MySQL WHERE clauses for greater control over data filtering.

MySQL FAQs - Managing User Accounts and Access Privileges
A collection of 17 FAQs on MySQL user accounts and access privileges. Clear answers are provided with tutorial exercises on creating and deleting user accounts; setting and changing passwords; giving and removing user privileges; showing granted privileges and levels.

MySQL Migration: MyISAM to InnoDB
A tutorial explaining how to convert a production application from MyISAM format to InnoDB.

MySQL Date Queries
Don't use PHP to calculate date ranges; you can build the date range inquiry directly into your MySQL query. Here are some common examples of MySQL date queries.

Running Multiple MySQL Versions
How to run multiple versions of MySQL on the same Server.

Basic SQL optimization for MySql
It's important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how...

Mysql Sub Queries, introduction
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP, just let mysql do the work :-)

Backup MySQL With Cron Jobs
In this tutorial you will learn how to make and use a Cron Tab from within Cron Jobs installed on Cpanel. If your version of Cpanel does not contain Cron Jobs or your web host does not provide it there are other ways of using Cron Tabs but those shell methods will not be discussed in this tutorial.

Optimize MySQL tables for speed
Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.