How to Enable Case-Insensitive Regex Search in SQL SELECT

This article introduces how to make SQL SELECT regex searches case-insensitive in SQL programming language (scripting language) for handling databases.

SELECT u.id, u.url, u.title, u.visit_count, datetime(u.last_visit_time/1000000-11644473600,'unixepoch','localtime') AS last_visit_time FROM urls AS u
WHERE u.url REGEXP "@ARG1"
    AND u.title REGEXP "@ARG2"
order by last_visit_time desc
LIMIT @ARG3 OFFSET @ARG4

↓

SELECT u.id, u.url, u.title, u.visit_count, datetime(u.last_visit_time/1000000-11644473600,'unixepoch','localtime') AS last_visit_time FROM urls AS u
WHERE LOWER(u.url) REGEXP "@ARG1"
    AND LOWER(u.title) REGEXP "@ARG2"
order by last_visit_time desc
LIMIT @ARG3 OFFSET @ARG4

The idea is to search against the lowercase version.

MySQL regex query case insensitive - Stack Overflow