Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 `introtext` LIKE CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and Replace a...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

AHK Countdown Tooltiphttps://joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 should sell, sell, sell." Joke10:="Not so much of a has-been, more of a definite won't be." Joke11:="If you see two people talking and one looks bored, he's the other one." ; make program select one joke in this instance Random, JokeIndex, 1, 11...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 or recommended for flying - Pilot: know a flight club? send us the details. - Pilot: start stop log notes - Pilot: talking timer - Pilot: profile photos need to be admin approved - Pilot: usernames may be changed by admin if deemed inappropriate -...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 just a setting in the BIOS if your motherboard supports it (I had no idea whether my motherboard supported it as it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't work, then I found you need to do an extra step in...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *

ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory level or stock check of all the products that are currently listed...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 Widget page into another published Creator page (idem). CORS Policy error(s): Check your design as you can have a JS widget talking to Zoho. You won't be able to pull/download files, even published ones, but you can display published image URLs (see...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

A for loop within a for loop in MS-DOShttps://joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 A quick note for myself as I'd forgotten how to do this (we're talking technology belonging to the 90s - MS-DOS v6.22). The example wants to loop through a directory and then loop through the line it finds. Why? I use another technology for automation...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB