Jack Barker jibbius

## drop_table_like.sql
/*
 *  MySQL - Drop Tables WHERE tablename like();
 */


SET @tables = NULL;
SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables FROM information_schema.tables
  WHERE table_schema = 'db_1' AND
(
   table_name LIKE BINARY 'wp_bp_%'

## Find_DB_TableColumn.sql
/******************************************
FIND DB TABLES/COLUMNS BY NAME
- Use this script to find all columns, with a name that is similar to
  the search term
*******************************************/


/* Define column name to search for */
DECLARE @term varchar(20) = ''; -- e.g. 'user', 'gst', 'cpi'...etc
                                -- leave blank to return EVERY database table + column.

## Clear IE icon cache.bat
REM
REM This script is supposed to clear the icon cache, for "favourites" in IE.
REM You may also need to delete cache/browsing history/cookies...etc
REM

cd /d %userprofile%\AppData\Local
attrib -h IconCache.db
del IconCache.db
pause

## Snagit_ImgPath.vbs
'Snagit: Send Captured File's Path To Clipboard
'--------------------------------------------------------------
'- Ensure snagit is configured to save your capture as a file, that is then sent to an application.
'- Select this script as the application.
'- The script will then save the file's path to the clipboard.

Dim Clipboard
Set args = WScript.Arguments
if args.length > 0 then
  arg1 = trim(args.Item(0))