Understanding MySQL for PHP
Understanding MySQL for PHP is the new series of videos where I'm explaining what MySQL is and how to use it to create your own database. Every week we will be publishing the new video to add to this series.

Advanced search form for your website with PHP and MySQL
This tutorial explains how to create the advanced search form for your website with PHP and MySQL using text fields, dropdown menus, radio buttons and check boxes. You will learn how to create database, how to define relationships between different tables and how to create search form which populates relevant information from the database and displays then on the page depending on selection made.

MySQL Tutorials - Table Column Types for Different Types of Values
This provides tutorial notes on table column types. Topics include column types for character strings, bit strings, exact numbers, approximate numbers, data and time values.

SQL Encryption Functions
There are two ways of securing data in a database: hashing and encryption. Hashing usually prevents you from obtaining the original string. Encryption allows you to obtain the original string (through decrypting). This is only possible if you know the encryption method, and the key that was used to encrypt it.

SQL Functions - String Functions
SQL provides a large amount of functions for string manipulations. Learn how to convert and use SQL Functions.

SQL Functions - Math Functions
Just like how programming languages have functions built-in to allow you to do common tasks easily. So does SQL. A lot of these functions are mathematical. Some of them are more useful than others.

SQL Date Functions - Converting and Using
SQL provides a lot of functions for manipulating dates in a database. You can store values in a date field or a datetime field. If you store the dates as unix_timestamps you can get a lot more flexibility with dates. In fact, this is usually what is done when you are using PHP with the database.

Writing SELECT queries for SQL databases
When you want to get results from a database you issue a select query. With this query you can limit the results based on certain criteria, sort it, and subsort it. You can do a lot with this including selecting data from multiple tables.

How to Fight Spam in Forums
How to Fight Spam in Forums like phpbb and Vbulletin

MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries
A collection of 16 FAQs on MySQL SELECT statements with JOIN and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations.

MySQL Tutorials
Free, easy, step by step tutorials on MySQL development. It gets you started with MySQL the easiest and fastest way.

5 Useful MySQL Functions And Control Flows
If statements have been a life saver on many occasions. They are invaluable for checking a value then returning another value different from the one stored in the table...

[BEGINNER] The MySql basics
A powerfull tutorial about MySql, it will introduce you to the scripting language MySql.

[MYSQL] functions/queries list
A list of usefully mysql functions and queries with short description for each function and exmaples.

Connecting to MySQL database from PHP
This tutorial will show you how to connect to MySQL database from PHP script.