Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
--Tested and working as of 2020-07-17
select
version as Current,
(
select
substr(
result,(
(
select
instr(result, 'Current Version ')
from
curl
where
url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
) + 16
),
5
) as Latest
from
curl
where
url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
) as Latest
from
programs
where
name like '%notepad++%'
and version < (
select
substr(
result,(
(
select
instr(result, 'Current Version ')
from
curl
where
url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
) + 21
),
6
) as Latest
from
curl
where
url = 'https:' || '/' || '/' || 'notepad-plus-plus.org'
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment