findstr command to find a phrase instead of a single word [closed]

Question

findstr /S "stored procedure" *.*

returns all the files with the string "stored" as opposed to "stored procedure".

Does anyone know what I am doing wrong? Thanks

Answer 1

You need to use the /c: option to tell findstr to search for the entire string not to search for individual components. Your command will find any file with "stored" or "procedure".

findstr /S /c:"stored procedure" *.*

Will find any files with the string "stored procedure" in them.