If you're looking for every instance of a particular character string, you can use this:

select *

from mytable

where bus_name like '%costco%'