Explore BrainMass

SQL Command

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

Any ideas will be very helpful.

© BrainMass Inc. brainmass.com October 24, 2018, 5:51 pm ad1c9bdddf

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.

See Also This Related BrainMass Solution

SQL Command to Add MATH SCOPE to the STUDENT Table

1. Write the SQL command to add MATH SCOPE to the STUDENT table.

2. Write the SQL command to add SUBJECT to TUTOR. The only values allowed for SUBJECT will be "Reading", "Math", and "ESL".

View Full Posting Details