Search for all files with a .sql extension in folders and sub folders

Question

I want to search for all files with the .sql extension in folders and sub-folders (recursive).

How can I do this?

score 4 · Answer 1 · 2011-12-11 14:41:16Z

up vote 4 down vote

Or...

find $directory_name -name \*.sql

For example

find / -name \*.sql

Or

find ~ \*.sql

(where ~ equates to /home/your_username/), or...

find /usr/local/share/ \*.sql

and so forth.

edited Dec 11 '11 at 14:41

answered Dec 11 '11 at 3:07

user8290

Barbarrosa · Answer 2 · 2011-12-11 01:59:08Z

up vote 1 down vote

Run this in the command line:

cd / && find | grep '\.sql$'

Change '/' to the directory you want to search.

The find command is able to accomplish the task without grep (using extra options), but I find the above usage more convenient.

In order, the above command:

Changes the current directory to the root directory (cd /)
Lists all files and directories at and below the current directory (find)
Filters the files and directories for anything that ends with '.sql' (| grep '\.sql$')

edited Dec 11 '11 at 1:59

answered Dec 10 '11 at 23:52

Barbarrosa
38717

	thanks, can you explain it? your using grep and passing its output to find? – Blankman Dec 11 '11 at 1:50
	Vice versa, actually. I'm using find and passing its output to grep. I added a more detailed explanation above. – Barbarrosa Dec 11 '11 at 2:00
	would this work on a Mac also? I tried 'find \| grep '\.sql$' and it outputted the usage help info. – Blankman Dec 11 '11 at 3:14
	find is a powerful tool and you really do not need to pipe the output to grep. This is a nice link - content.hccfl.edu/pollock/unix/findcmd.htm – bodhi.zazen Dec 11 '11 at 3:52
	`find` has already filter capabilities – enzotib Dec 11 '11 at 12:04

2 Answers