:::: MENU ::::

How To Use Wildcard Characters in MySQL statements

You’ll need to make use of wildcard characters to perform powerful searches in MySQL. The 2 wildcard characters that you can use in “LIKE”-queries in MySQL are: % which matches 0 or more characters _ which matches exactly one character To search for a date, you can use a query like the following, which gives Read More

How to correctly display CSV files (Excel 2013)

Excel 2013 has an issue displaying files in CSV format that other versions of Excel doesn’t seem to have. To fix this, you’ll just need to open the CSV file with any text editor (like Notepad), and add the following as the first line: sep=, This sets the comma (or any other character that you Read More

The Best Index Fund Portfolio Mix For Non-US Investors

I hear a lot of references to Warren Buffett whenever I look at investment methodologies and techniques, e.g. “Follow how Buffett Invests” or “This is what Buffett would have done”, but it’s never what Buffett has specifically said so himself. Except for this: “There are a few investment managers, of course, who are very good Read More

Best Quest Protein Bar Flavors

I’ve been trying the many various flavors that Quest has for its awesome protein bars, and after getting box after box from iHerb, this is my personal ranking of their flavors: 1. Cookies and CreamMy favorite flavor, with bits of cookies and cream in the bar. Tasty! 2. Cinnamon RollRidiculously good. Tastes just like a Read More

How to redirect one domain to other domain with all query string variables (htaccess)

If you ever have the need to move domain names, the following .htaccess code will help move all visitors to your second domain name. This method also preserves your URLs’ query string variables, so there’s a less likely chance of something breaking. You can use this: RewriteEngine On RewriteCond %{HTTP_HOST} firstdomain.com$ RewriteRule ^(.*)$ http://www.seconddomain.net/$1 [L,R=301]