Using Logical Operators
You can also use the logical operators AND, OR, and NOT in your MySQL WHERE queries to further narrow down your selections. Following Example shows one instance of each, but you can mix and match them in any way you need.
SELECT author,title FROM classics WHERE author LIKE "Charles%" AND author LIKE "%Darwin"; SELECT author,title FROM classics WHERE author LIKE "%Mark Twain%" OR author LIKE "%Samuel Langhorne Clemens%"; SELECT author,title FROM classics WHERE author LIKE "Charles%" AND author NOT LIKE "%Darwin";
I’ve chosen the first query, because Charles Darwin might be listed in some rows by his full name, Charles Robert Darwin. Thus, the query returns publications as long as the author column starts with Charles and ends with Darwin. The second query searches for publications written using either Mark Twain’s pen name or his real name, Samuel Langhorne Clemens. The third query returns publications written by authors with the first name Charles but not the surname Darwin.