What countries have the word Republic
as part of their name?
+---------------------------------------+ | name | +---------------------------------------+ | Dominican Republic | | Central African Republic | | Congo, The Democratic Republic of the | | Czech Republic | +---------------------------------------+ 4 rows in set (0.00 sec)
SELECT name FROM countries WHERE name LIKE '%Republic%';