using sql to update mailwizz custom fields
Coding
Pinakin Patel
PHP Web Developer
Recursively deleting files by extension value on linux
Replace . with path to folder ie...
Installing Docker and Docker Desktop on Linux Mint
These instructions are merged from...
How To Open Website On Startup with a Raspberry Pi
The following instructions have been used to...
Creating a SQL based on the products export CSV in Shopify
I used chatgpt to create this SQL based on the...
using imapsync on terminal
how to start a sync from terminal using the excellent imapsync
how to increase increase by a percentage and round to the nearest 5p
select pr.*, round((pr.price * 1.2), 2 ) as...
Command to show the top ten file requests from an apache log file
You can use a combination of terminal commands like awk, sort, uniq, and cut to analyze an Apache log file and find out which files are called the most and the bandwidth they are using.
Function to create a slug in MySQL
Use this to create a slug from a string field.
using curl to fetch a file using sftp with password in command
If you need to download a file using SFTP from the command line, you should use the sftp or scp commands.
updating custom field values in mailwizz using direct SQL
In mailwizz you can create custom fields which get assigned a field_id in the database table. So in my case the customer field is called rank and the field_id = 24.
Format Telephone numbers into US format in MySQL
Learn how to format 10-digit telephone numbers stored as 1234567890 into the standard US style 123-456-7890 in MySQL. This post shows a simple SELECT query using CONCAT, LEFT, MID, and RIGHT to display a formatted_phone field for orders from US, Canada, and Puerto Rico.