Explore BrainMass

Explore BrainMass

    SQL Command

    This content was COPIED 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 March 4, 2021, 6:00 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

    ADVERTISEMENT