Just to extend the idea of a guid search, here's an example of how that might look if you wanted to search across multiple tables.
select ea_guid AS CLASSGUID, Diagram_Type as CLASSTYPE, 't_diagram' as CLASSTABLE, Name, Author, CreatedDate, ModifiedDate, ea_guid as GUID from t_diagram where ea_guid like '*<Search Term>*'
union
select ea_guid AS CLASSGUID, Object_Type as CLASSTYPE, 't_object' as CLASSTABLE, Name, Author, CreatedDate, ModifiedDate, ea_guid as GUID from t_object where ea_guid like '*<Search Term>*'
union
select ea_guid AS CLASSGUID, 'Attribute' as CLASSTYPE, 't_attribute' as CLASSTABLE, Name, null, null, null, ea_guid as GUID from t_attribute where ea_guid like '*<Search Term>*'
union
select ea_guid AS CLASSGUID, 'Operation' as CLASSTYPE, 't_operation' as CLASSTABLE, Name, null, null, null, ea_guid as GUID from t_operation where ea_guid like '*<Search Term>*'
order by 4