Untitled

Account Overview - Getting Started - Control Panel Overview - Chapter 1 FTP Software Setup
Chapter 2 SSH / Telnet Setup - Chapter 3 Email Software Setup - Chapter 4 CGI-Bin - Chapter 5 Secure Server
Chapter 6 FormMail - Chapter 7 MS FrontPage - Chapter 8 CGI Scripts - Chapter 9 ASP - Active Server Pages
Chapter 10 JSP - Java Server Pages - Chapter 11 PHP - Chapter 12 Real Audio/Real Video
Chapter 13 File Manager - Chapter 14 Mail Manager - Chapter 15 Changing Passwords - Chapter 16 Site Statistics
Chapter 17 Network Tools - Chapter 18 FTP Manager - Chapter 19 Backup Manager - Chapter 20 Password Protect Directories
Chapter 21 Custom Error Pages - Chapter 22 MySQL & PhpMyAdmin - Chapter 23 Mime Types - Chapter 24 CronTab
Chapter 25 Entropy Chat - Chapter 26 Akopia Shopping Cart - Chapter 27 Search Engine Submission
Chapter 28 PGP & PGP Mail - Chapter 29 Subdomains

Chapter 22 - 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.

Back To Top