Skip to content

Instantly share code, notes, and snippets.

View J2112O's full-sized avatar

Josh Otwell J2112O

5 followers · 2 following
View GitHub Profile
@J2112O
J2112O / text3.sql
Created May 25, 2022 11:35
SELECT first_name, last_name
FROM friends
WHERE last_name BETWEEN 'A' AND 'C';
Empty set (0.00 sec)
@J2112O
J2112O / text2.sql
Created May 25, 2022 11:33
SELECT first_name, last_name
FROM friends
WHERE last_name BETWEEN 'A' AND 'D';
@J2112O
J2112O / text.sql
Created May 25, 2022 11:32
SELECT first_name, last_name
FROM friends
WHERE last_name BETWEEN 'M' AND 'Z';
@J2112O
J2112O / first_last.sql
Created May 25, 2022 11:31
SELECT first_name, last_name
FROM friends;
@J2112O
J2112O / collate.sql
Created May 25, 2022 11:30
SELECT @@character_set_database AS char_set, @@collation_database AS collat;
@J2112O
J2112O / between_bday.sql
Created May 25, 2022 11:28
SELECT first_name, birthday
FROM friends
WHERE birthday BETWEEN '1975-05-01' AND '1975-09-01';
@J2112O
J2112O / friends.sql
Created May 25, 2022 11:27
SELECT first_name, birthday
FROM friends;
@J2112O
J2112O / empty_set.sql
Created May 25, 2022 11:25
SELECT category_id, name
FROM category
WHERE category_id BETWEEN 5 AND 1;
Empty set (0.00 sec)
@J2112O
J2112O / greater.sql
Created May 25, 2022 11:24
SELECT category_id, name
FROM category
WHERE category_id >= 1 AND category_id <= 5;
@J2112O
J2112O / between.sql
Created May 25, 2022 11:22
SELECT category_id, name
FROM category
WHERE category_id BETWEEN 1 AND 5;