MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuel d'instructions télécharger pdf (Page 73)

Using a web page to list trips 63

Consider a table named Clients to hold information about people with the following

rows:

To select the columns named LastName and FirstName, use the following SELECT

statement:

SELECT LastName, FirstName FROM Clients

The results of this SQL statement contains the following data:

Using the SQL WHERE clause to limit the rows returned

To conditionally select data from a table, you can add a WHERE clause to the SELECT

statement resulting in the following syntax:

SELECT column_name FROM table_name WHERE column condition value

With the WHERE clause, you can use any of the following operators:

LastName FirstName Address City

Jones Tom 12 State St Boston

Adams Anita 521 Beacon St Boston

Green Peter 1 Broadway New York

LastName FirstName

Jones Tom

Adams Anita

Green Peter

Operator Description

=Equal

<> Not equal

> Greater than

<Less than

>= Greater than or equal

<= Less than or equal

BETWEEN Between an inclusive range

AND Joins one or more conditions

OR Joins one or more conditions

LIKE Specifies a search for a pattern in a column. You can use a "%" sign to

define wildcards (missing letters in the pattern) before and after the

pattern.

1 2 ... 68 69 70 71 72 73 74 75 76 77 78 ... 153 154

Pas de commentaire

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuel d'instructions Page 73