DB2 REPLACE Function
The DB2 REPLACE function replaces all occurrences of a search string within a source string. If the search string is not found within the source string, the original string is returned unchanged.
Blog
Portfolio Project: Fit Uniforms
Fit Uniforms was running an e-commerce website based on WordPress and Jigoshop that was in need of some help. They came to me wanting to optimize and redesign their website. They wanted a website that was professional, easy to navigate, and mobile friendly. A website that allowed mobile devices to easily complete a purchase. In addition, they also wanted to move to a new hosting provider, one that provided better features and more stability.
Portfolio Project: MRP Design Engineering
I recently completed work on a new project for MRP Design Engineering. We took their existing website, built using the SnippetMaster web editor, and migrated it to the WordPress platform with a new look and feel.
MySQL REGEXP (Regular Expression) Operators
MySQL offers the ability to use regular expressions to perform complex searches against your data. A regular expression is a tool that provides for a concise and flexible way to identify strings of text based on user-defined patterns.
Listing Subcategories on a Category Page in Magento
I recently was working on a Magento Commerce website for a client that wanted to display all of the subcategories of a category on the category page, to improve basic navigation, and to further enhance and show the range of products that they carried.