Skip to content

Instantly share code, notes, and snippets.

🤷‍♀
Shifting bits around the world

Kevin Peters igeligel

🤷‍♀
Shifting bits around the world
Block or report user

Report or block igeligel

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
View 1.sql
SELECT * FROM example_table WHERE example_column ~* 'mel';
View 1.sql
SELECT * FROM example_table WHERE example_column ILIKE '%mel%';
View 1.sql
SELECT * FROM example_table WHERE LOWER(example_column) LIKE '%mel%';
View 1.md
id ... example_column ...
... ... ... ...
205 ... Mel ...
206 ... Melissa ...
207 ... Mel ...
209 ... Emelio ...
... ... ... ...
View 1.sql
SELECT * FROM example_table
WHERE example_column LIKE '%mel%'
OR example_column LIKE '%Mel%';
View 4.js
const name = "Melissa";
const includesPattern = name.toLowerCase().includes("mel");
console.log(includesPattern);
// Outputs true
View 3.js
const name = "Melissa";
const includesPattern = name.includes("mel");
console.log(includesPattern);
// Outputs false
View 2.js
const name = "Emilio";
const includesPattern = name.includes("mel");
console.log(includesPattern);
View 1.js
const numbers = [1, 4, 9];
const includesFour = numbers.includes(4);
console.log(includesFour);
View 1.md
id ... example_column ...
... ... ... ...
203 ... Max ...
205 ... Mel ...
207 ... Mel ...
... ... ... ...
You can’t perform that action at this time.