Explore BrainMass
Share

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.
SELECT PUBLISHER_NAME
FROM PUBLISHER
WHERE PUBLISHER_NAME LIKE '%and%'
;

Any ideas will be very helpful.

© BrainMass Inc. brainmass.com October 24, 2018, 5:51 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/sql-command-23184

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
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