Some SQL commands I use every now and then, in current state or modified versions

sql-snippets

# SQL Like Usage
# - - - - - - - - - - - - - - - - - - - - - - - - - - 
SELECT * FROM asdf WHERE asdf LIKE 'asdf%';

UPDATE asdf
SET asdf = ""
WHERE asdf LIKE '/images/uploads/asdf%';

UPDATE asdf
SET asdf = replace(asdf,'/images/uploads/logos/cropped/ready/','/images/uploads/logos/')
WHERE asdf LIKE '/images/uploads/logos/cropped/ready/%';



# import SQL file into table
# - - - - - - - - - - - - - - - - - - - - - - - - - - 
LOAD DATA
INFILE '~/Desktop/csv.txt'
INTO TABLE asdf
COLUMNS TERMINATED BY ',' 
LINES TERMINATED BY '\n';