Database Reference
In-Depth Information
temporarily connecting the tables to each other. This one may seem tricky. So
take your time and don't get frustrated. If necessary, refer back to
Combining
Limit the results to 25 rows. If you do it right, you should get the same 25 birds
from the second
SELECT
of this exercise, but with two more fields of data. Be
sure to exclude rows in which the
common_name
column is blank.
3. Use the
SELECT
statement in conjunction with
REGEXP
in the
WHERE
clause to
get a list of birds from the
birds
table in which the
common_name
contains
the word “Pigeon” or “Dove” (this was covered in
Expressions and the Like
)
.
Give the field for the
common_name
column the alias
>Type of Columbidae
—
that's the name of the family to which Doves and Pigeons belong.