Other queryes examples:
Removing content:

REMOVE FROM table WHERE field = 'value'

Updating content:

UPDATE table SET field1 = 'value1', field2 = 'value2'

Selecting distint content:

SELECT name, email FROM table WHERE email = 'email value'

Useful functions:
mysql_num_rows - get table total rows - www.php.net/mysql_num_rows
mysql_stat - show the mysql status - www.php.net/mysql_stat
mysql_info - show MySQL version info - www.php.net/mysql_info


More references:
MySQL manual: http://www.mysql.com/doc/en/index.html
PHP official site: http://www.php.net

That's it! Hope this help you start using MySQL.