Here was my case, I saw some text shown in web pages were wider than defined width because some non-space strings were extremely longer than… Read More »PHP Line Break Long String
As you may already know that URLs are always the shorter the better for both visitors and search engines to understand your web pages at… Read More »Rewrite Query String into Plain URL
preg_match Are preg_match and preg_replace Multi-Byte Safe? The direct answer is yes. Both preg_match and preg_replace functions can be multi-byte safe. But at least, you… Read More »Preg_Match for Multi-Byte
You may put some values which are potentially numeric in a VARCHAR column, and you would like to find them out for more operations. Unfortunately,… Read More »Regular Expression Number Pattern
Word Boundaries The usual word boundaries in regular expression is b, but MySQL takes POSIX-liked [[:<:]] and [[:>:]] as word boundaries. Now my question is… Read More »MySQL Word Boundaries