This is basic SharePoint knowledge
SPQuery query = new SPQuery();
query.Query = "<Where>
<Eq>
<FieldRef Name='myFieldName' />
<Value Type='Text'>value to test for</Value>
</Eq>
</Where>
";
SPList list = web.Lists["myList"];
SPListItemCollection items = list.GetItems(query);