Queries with Select
Now let us run some simple queries against the data that we imported into the songs
domain and get familiar with the syntax. Using one of the three examples discussed, you can create the songs
domain in your SimpleDB database. Using either the SDBtool Firefox plugin that was discussed in Chapter 2, Getting Started with SimpleDB, or the PHP Try-SQL-Queries sample program, you can try these SQL queries as well as variations on them.
Comparison operators
Select all attribute/values from songs
where the Song
attribute is My Way
. It is important to note that domains and attributes are case-sensitive.
Enter:
SELECT * FROM songs WHERE Song = 'My Way'
Result:
Item name |
Song |
Artist |
Year |
Genre |
Rating |
---|---|---|---|---|---|
112222222 |
My Way |
Frank Sinatra |
2002 |
Easy Listening |
**** 4 stars Excellent |
The list of available comparison operators includes =, !=, >, >=, <
, and<=
.
Greater than
Retrieve all songs where the Year
is greater than 2000
.
Note
In Chapter 4, The SimpleDB Data Model, we...