MySQL is virtually irrelevant - all that changes is the Connection String, and some minor SQL syntax.

What matters is ADODB code, and you can find several examples in our FAQs - such as the "ADO Tutorial" (parts of which are similar to what you have already), and "...Further Steps" which extends it in various ways - including a search feature.