Credits

Tuesday, September 15, 2009

Filter Table Records Through MySQL

In writing database systems, programmers would normally work with records of information stored in various tables in different databases. However, one of the basic functionalities of database operation is filtering for records. When we say, “FILTER,” it means that only certain records are picked out from the rest of the information just like refrigerator water filters or pool filters that remove unwanted elements from the rest of the stuffs.

With the increasing growth of MySQL as database platform, we use the command SELECT to filter out only records that meet certain conditions.

For instance, if from the table “Student,” I want only to display idnum equal to 20091010, I can type in my MySQL Query Browser:

SELECT * FROM ‘ENROLMENTDATABASE’,’STUDENTTABLE’ WHERE IDNUM=’20091010’;

Knowing SELECT command and its full clauses can be powerful tool in any database program. Do check your MySQL reference manual for complete syntax of SELECT.

AddThis