How to Match Word Boundary using SQL? July 6, 2014 database, programming languages, sql, SQL No Comments 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 … [Continue Reading...]
Shrink WordPress Database Usage June 19, 2013 beginner, database, FTP, mysql, optimization, sql 1 Comment 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 … [Continue Reading...]