SQL query useful when we need to detect users with wrong timezone format (number instead of name or blank string)

joomla-wrong-timezone-detector

SELECT * FROM `#__users` WHERE 
(
  `params`  LIKE('%timezone":"_"%') OR
	`params`  LIKE('%timezone":"__"%') OR
	`params`  LIKE('%timezone":"___"%') OR
	`params`  LIKE('%timezone":"____"%') OR
	`params`  LIKE('%timezone":"_____"%')
)
AND
    `params` NOT LIKE('%timezone":"UTC"%')
AND
    `params` NOT LIKE('%timezone":""%');