If you ever want to use the Spotlight search functionality from a Mac OS X terminal window, you can access the same Spotlight information using the
mdfind command. Here are a few examples of how to use
mdfind to find files and directories on your Mac OS X system.
To find files with the word "alexander" in them, from a Terminal window you can use
mdfind like this:
Now, if you just want to find a file using a portion of the filename, use this