Real-World Code Search Recipes/Find `SELECT *` usage

Audit SQL anti-patterns in code or migrations.

Section: Refactor recipes

Find `SELECT *` usage

bash
bash
rg -i 'select\s+\*' .
Explanation

Helpful for performance and style audits.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Refactor recipes
Find hard-coded URLs
Search for HTTP(S) URLs in source and config.
OpenIn sheetbashsame section
Find debug logging in source code
Locate `console.log` usage across a codebase.
OpenIn sheetbashsame section
Find deprecated API calls
Search for an old method across target languages.
OpenIn sheetbashsame section
Find a React hook across TSX files
Search only the frontend component surface.
OpenIn sheetbashsame section
Search for AWS access key patterns
Look for common credential shapes.
OpenIn sheetbash1 tag match
Search for 5xx errors in logs
Find common server-side error lines.
OpenIn sheetbash1 tag match