CODEWITHSUNDEEP
mysqlwildcardsql-like
Matthew Schmitt
Matthew Schmitt

Reputation: 65

MySQL searching for a keyword

I need to find all the plubisher names that contain the word AND. The teacher showed us his output file and it shows the following results:

#12.
+--------------------------+
| PublisherName            |
+--------------------------+
| Farrar Straus and Giroux |
| McPherson and Co.        |
| Simon and Schuster       |
| Thames and Hudson        |
+--------------------------+
4 rows in set (0.00 sec)

My code that I used is:

SELECT PUBLISHER_NAME
FROM PUBLISHER
WHERE PUBLISHER_NAME LIKE '%AND%';

However, my results pulls in an extra publisher: Random House due to the and in random.

Can someone point me in the right direct on what I am doing wrong?

Thanks

Upvotes: 0

Views: 26

Answers (1)

Stian Hvatum
Stian Hvatum

Reputation: 92

Try adding spaces between the text and the wildcard.

SELECT PUBLISHER_NAME
FROM PUBLISHER
WHERE PUBLISHER_NAME LIKE '% AND %';

Upvotes: 2

Related Questions