How to search entire xml column for a string in sql?

I want to create a query that searches a string in the entire xml column.

My table name is msg. it has two fields ID and xmlmsg ID is of type INT and xmlmsg is of type xml.

I wants to write a query to search for '123456' in xmlmsg column and return the id.