Can someone point me to a source, like CWSS perhaps, where I can look up a soldier who served, legend says, in the Mexican War?

(I know this is pretty far afield or far enough off-topic to block it, and if so, I completely understand.)