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 you everything that happened from 10 to 19 August of 2015, between 9:01am to 9:09am. SELECT * FROM `yourTable` WHERE `datetime` LIKE ‘2015-08-1_ 09:0%’

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 need) as the separator. Now just save and close the file from your text editor, and then open it with Excel 2013.

Site Footer

Sliding Sidebar

Disclaimer

The contents on this blog are not intended as professional advice. The author disclaims any liability, loss, or risk taken by individuals who directly or indirectly act on the information contained on this blog.