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.
WHERE PUBLISHER_NAME LIKE '%and%'
Any ideas will be very helpful.© BrainMass Inc. brainmass.com September 23, 2018, 3:53 pm ad1c9bdddf - https://brainmass.com/computer-science/sql/sql-command-23184
<br>Hint: If you are looking for the "conjunction" AND, use the fact that there will be "spaces" before ...
SQL Commands are emphasized.