using sql to update mailwizz custom fields
SQL
Pinakin Patel
PHP Web Developer
Creating a SQL based on the products export CSV in Shopify
I used chatgpt to create this SQL based on the...
how to increase increase by a percentage and round to the nearest 5p
select pr.*, round((pr.price * 1.2), 2 ) as...
Function to create a slug in MySQL
Use this to create a slug from a string field.
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
if you have a telephone field in a table where numbers have been entered in the format 1234567890 then use this to format it as 123-456-7890
Driving School Price Comparison using wpDataTables
How to create a searchable and sortable data...
Resetting your wordpress password using SQL
https://www.domain.com/help/article/wordpress-how-to-change-or-reset-your-admin-passwordhttps://www.domain.com/help/article/wordpress-how-...
Massing deleting customers except admins in x-cart for for a test server
When creating a test store for developers to work on you should clean down any customer data for privacy
Sorting products so out of stock appear at the bottom in X-Cart 4
These instructions are for sorting products in...
How to reset a wordpress admin password when you server will not send out the password reset email
Need to reset the admin password on wordpress directly in SQL?
How to Import a .sql file using terminal
How to import a .sql file using terminal. You mush have the database username, password and database name at hand