The Ultimate
Snippet Library.

Perform Basic Full-Text Search with LIKE

Discover how to perform simple full-text searches in SQL using the LIKE operator and wildcards (%) to find records matching partial strings within text fields.

Retrieve Related Data with LEFT JOIN

Master how to use LEFT JOIN to retrieve records from one table along with all matching records from another, including cases where no match exists in the second table.

Count Distinct Values Per Group with HAVING

Learn to count the number of unique occurrences of a field within different groups using GROUP BY and COUNT(DISTINCT ...), filtering results with HAVING.

Delete Duplicate Rows Keeping First Occurrence

Efficiently remove duplicate entries from your database table based on specific columns in MySQL, ensuring only one unique record remains for each set of duplicates.

Automate Actions with Eloquent Model Observers

Centralize logic for responding to Eloquent model lifecycle events like creation, update, and deletion using dedicated observer classes.

Perform Batch Updates and Deletes Efficiently

Execute mass updates or deletes on multiple records without retrieving and iterating over each individual Eloquent model, optimizing database operations.

Configure Custom Database Connections and Table Names

Learn how to configure Eloquent models to use a different database connection or a custom table name than Laravel's default conventions.

Reusable Query Filters with Eloquent Local Scopes

Define reusable query constraints within your Eloquent models to simplify filtering and improve code readability for common data retrieval patterns.

Filter Records Based on Related Model Existence

Efficiently query parent models based on the existence or absence of specific related records using Eloquent's `has` and `whereHas` methods.

Load .env File into Bash Environment

Learn how to securely load environment variables from a .env file into your Bash session or scripts, enabling easy configuration management for web projects.

Perform Authenticated API Request with curl

Discover how to use `curl` in Bash to make authenticated POST requests to web APIs, including sending JSON payloads and authentication headers.

Update Configuration Value in File using sed

Learn how to use `sed` in Bash to programmatically update specific configuration values within text files, useful for automated server setups.