Cacher is the code snippet organizer for pro developers

// ----------------------------------------------
// Author: Romain Blanchard
// Date: 21.01.2014
// Description: Get SharePoint item (SPListItem) using CAML from column's name.
// ----------------------------------------------

SPList Library = web.Lists[<ListName>];
SPQuery ItemQuery = new SPQuery();
ItemQuery.Query = "<Where><Eq><FieldRef Name=\"<ColumnName>\" /><Value Type='Text'>" + <Value> + "</Value></Eq></Where>";
SPListItemCollection ListItemCollection = Library.GetItems(ItemQuery);
SPListItem item = ListItemCollection[0];