PHP Line Break Long String
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
Regular Expression
Rewrite Query String into Plain URL
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 for Multi-Byte
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
Regular Expression Number Pattern
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
MySQL Word Boundaries
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
How to Use REGEXP or RLIKE to Select Strings First Positioned or Space Prepended
In this case, I would identify a string (e.g. 'mountain view') which is a leading or white space prepended string and it should be appended… Read More »How to Use REGEXP or RLIKE to Select Strings First Positioned or Space Prepended
How to Make Switch-Case Smaller and Smarter
In the following example, there are only four possible outputs represent four quarters in the switch-case. <?php $month = "4"; ... switch ($month) { … Read More »How to Make Switch-Case Smaller and Smarter