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

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.

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:

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

I know that this is an old post, but i am pretty new at this and i've found an easy way to find all files of a certain extension in a directory and its children subdirectories. Well you first navigate to the parent Directory then find . -name '*.sql' and that will find you all files with .sql extension in the directories and its subdirectories.

In my case i wanted to delete all .xml files in the directory and its subdirectories, so what i did more is that i added remove as in here find . -name '*.xml' | xargs rm

Hope this help someone :)