Share
Explore BrainMass

SQL Command

Find the name of each publisher containing the word "and". (Hint: Be sure that your query selects only those publishers that contain the word "and" and not those that contain the letters "and" in the middle of a word. For example, your querry should select the publisher named "Farrar and Giroux," but should not select the publisher named "Random House.") This process is done by SQL.
I tried this but keep getting Random House in my query.
SELECT PUBLISHER_NAME
FROM PUBLISHER
WHERE PUBLISHER_NAME LIKE '%and%'
;

Any ideas will be very helpful.

Solution Preview

<br>Hint: If you are looking for the "conjunction" AND, use the fact that there will be "spaces" before ...

Solution Summary

SQL Commands are emphasized.

$2.19