https://www.dangtrinh.com/
https://www.dangtrinh.com/
mysql: delete records with special characters
DELETE FROM [table] where First_Name REGEXP '[^a-zA-Z0-9- ]' OR Last_Name REGEXP '[^a-zA-Z0-9- ]' OR Company REGEXP '[^a-zA-Z0-9-& ]' OR website […]
ubuntu: add user to another group
source: https://www.howtogeek.com/50787/add-a-user-to-a-group-or-second-group-on-linux/ usermod -a -G examplegroup exampleusername
mysql: extract domain from email
SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)
mysql: extract domain from url
SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(a0_custom_import_contacts.website, '//', '.'), '/', 1), '.', -2)
mysql: capitalize first word of all words
credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/ create a function: CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT; DECLARE i […]
hemingway
pbs
python imaplib: search emails with specific subject
result, numbers = mail.uid('search', None, '(SINCE "' + date_start + '" BEFORE "' + date_end + '") (SUBJECT "Failure")')
postgresql: incorrect table sizes
do a VACUUM FULL if you want to run this on python you need to set autocommit = True otherwise it […]