Interestingly, the Finder might go away before the command line. The first answer that popped into my head to give you was "mdfind"—and then I realized that it wasn't "by name," but rather by Spotlight metadata. File names have already hit the limit of infinitesimal usefulness.