How to Match Word Boundary using SQL?
In SQL, sometimes, you want to search a string field that contains a keyword, but as a whole word. So for example, if you search for ‘word‘, you do …
Category: database
Migrating PHPBB to the new Domain
PHPBB is a forum that is easy to use and powerful. I recently decided to migrate a phpbb forum to a new domain, in order to attract more traffic. …
Picture Explorer, Sort Pictures by Facebook Likes
October 4, 2013
algorithms, database, implementation, internet, mysql, optimization, php, programming languages, search, SEO, sorting, technical, tricks
No Comments
I have created an online page that allows people to upload any single photo to server. The URL to list all the photos (visible) is https://rot47.net/picture-gallery To add a photo …
Shrink WordPress Database Usage
My FTP provider (fasthosts) only allows 150MB maximum usage per database created. This is big enough for most personal usages. However, the other day, after I logined to the …
Database Optimisation Script in PHP
Well, sometimes, you probably need to optimise your MySQL tables. In order to avoid the hassle loggin to your remote SSH server, you probably want to write a script …