doing a query

[admin]

I have a table called "stock" with rows called "Make | Model | Color" what is the query to send to mysql to find al entrys in color that have the word dublin, and then display the values for the other two rows.

Also how would i launch that from a web page.

Thanks for your help