Skip to content

Instantly share code, notes, and snippets.

Jack Barker jibbius

Block or report user

Report or block jibbius

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@jibbius
jibbius / drop_table_like.sql
Created May 16, 2013
MySQL - Drop Tables WHERE tablename like();
View 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_%'
@jibbius
jibbius / Find_DB_TableColumn.sql
Created Apr 24, 2013
FIND DB TABLES/COLUMNS BY NAME - Use this script to find all columns, with a name that is similar to the search term
View 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.
@jibbius
jibbius / Clear IE icon cache.bat
Last active Dec 16, 2015
Clear IE icon cache: This script is supposed to clear the icon cache, for "favourites" in IE. You may also need to delete cache/browsing history/cookies...etc
View 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
@jibbius
jibbius / Snagit_ImgPath.vbs
Last active Dec 16, 2015
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.
View 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))
You can’t perform that action at this time.