2018-08-30

MySQL - How to use a case sensitive regular expression in a where clause

select *
from table_name
where field_name REGEXP '[A-Z]{3,}'
COLLATE utf8_bin
;

2018-08-26

Python/MySQL - How to overcome MySQL GROUP_CONCAT character limit

cursor.execute(
'SET SESSION group_concat_max_len = 1000000; \
SELECT a, b, c \
FROM table_name \
WHERE field_name = %s \
;'
, [
variable_for_where_clause
]
, multi=True
)