Rsa97

UPDATE `table`
  SET `num` = REGEXP_REPLACE(`num`, '[^0-9]', '');

UPDATE `table`
  SET `num` = REPLACE(REPLACE(REPLACE(REPLACE(`num`, '-', ''), '+', ''), '(', ''), ')', '');

SELECT COUNT(*) FROM `table` WHERE `column` = 'xxx';

hour = (new Date()).getHours();
if (hour == 23 || hour < 6) {
  ...
}

SELECT 
  (SELECT COUNT(*) FROM `user_hosting`) AS `user_hosting_count`,
  (SELECT COUNT(*) FROM `order_hosting`) AS `order_hosting_count`,
  ...