How to Change HTTP into HTTPS in WordPressDecember 18, 2019December 11, 2022Change HTTP into HTTPS After configuring SSL settings of the web server, now here comes a question: how can we change all HTTP URL into… Read More »How to Change HTTP into HTTPS in WordPress
MySQL String Occurrence CountJanuary 30, 2016December 18, 2022Case-Sensitive Occurrence Function Since there's no function to count occurrences in strings, so I create a customized function to meet the requirement as followings: create… Read More »MySQL String Occurrence Count
How to Resolve ERROR 1139 (42000): Got error 'repetition-operator operand invalid' from regexpSeptember 26, 2015December 13, 2022ERROR 1139 (42000) In the following example, we'd like to select the city name which are regular-expressly like (rlike or regexp) the string 'New York+',… Read More »How to Resolve ERROR 1139 (42000): Got error 'repetition-operator operand invalid' from regexp