How to Change HTTP into HTTPS in WordPress
Change 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
REPLACE
MySQL String Occurrence Count
Case-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 regexp
ERROR 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