Chapter 1
Account Overview

Chapter 2
Getting Started

Chapter 3
Control Panel Overview

Chapter 4
FTP Instructions

Chapter 5
SSH / Telnet

Chapter 6
Email Software Setup

Chapter 7
File Manager

Chapter 8
Change Password

Chapter 9
Mail Manager

Chapter 10
Site Statistics

Chapter 11
Mailing List

Chapter 12
Microsoft FrontPage

Chapter 13
Site Creation Tool

Chapter 14
Counters

Chapter 15
Protect Directories

Chapter 16
Redirect URL

Chapter 17
Search Engine

Chapter 18
Formmail

Chapter 19
PGP & PGP Mail

Chapter 20
Mime Types

Chapter 21
Anonymous FTP

Chapter 22
Archive Manager

Chapter 23
SSL (Secure Server)

Chapter 24
MySQL

Chapter 25
Shopping Cart

Chapter 26
CGI-bin

Chapter 27
Real Audio / Real Video

   

Chapter 24 - MySQL



Table Select

From this page you can perform a SELECT operation on the table.

The list box in the upper left contains the names of all the fields in the table. Select from the list box the columns you wish to see in your result set.

Any valid WHERE clause can be entered in the "Add search conditions" text box.

The field names and a text box are listed again under the "Do a 'query by example'" bullet. These can be used build a WHERE clause more easily than typing the entire clause into the textbox above. Each entry becomes a condition of the WHERE clause. The conditional operator used is LIKE which allows the wildcard operators "%" and "_"  to represent zero or more characters, and a single character, respectively. 

SELECT Name, Telephone
FROM Phonebook 
WHERE Id LIKE ‘Joe%’;
The wildcard characters can both appear in the same string and can appear more than one as needed. Note that using no wildcard characters is equivalent to using "=" instead of LIKE. LIKE is generally slower than "=" since MySQL must still check for wildcards characters. To use "=" or other conditions you must type them in the general WHERE clause textbox.

Press the Go button at the bottom of the page to process the select statement. If any records are found, they will be displayed in a table for you.