Kevin Peters igeligel

## 1.sql
SELECT * FROM example_table WHERE LOWER(example_column) LIKE '%mel%';

## 1.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                igeligel
                / 1.md
            
            
              Created
              October 27, 2019 14:20
            
          
id
...
example_column
...


...
...
...
...


205
...
Mel
...


206
...
Melissa
...


207
...
Mel
...


209
...
Emelio
...


...
...
...
...


## 1.sql
SELECT * FROM example_table
WHERE example_column LIKE '%mel%'
OR example_column LIKE '%Mel%';

## 4.js
const name = "Melissa";
const includesPattern = name.toLowerCase().includes("mel");
console.log(includesPattern);

// Outputs true

## 3.js
const name = "Melissa";
const includesPattern = name.includes("mel");
console.log(includesPattern);

// Outputs false

## 2.js
const name = "Emilio";
const includesPattern = name.includes("mel");
console.log(includesPattern);

## 1.js
const numbers = [1, 4, 9];
const includesFour = numbers.includes(4);
console.log(includesFour);

## 1.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                igeligel
                / 1.md
            
            
              Created
              October 27, 2019 14:17
            
          
id
...
example_column
...


...
...
...
...


203
...
Max
...


205
...
Mel
...


207
...
Mel
...


...
...
...
...


## how-to-query-with-postgresql-wildcards-like-a-pro.sql
SELECT * FROM example_table WHERE example_column LIKE 'M__';

## how-to-query-with-postgresql-wildcards-like-a-pro.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                igeligel
                / how-to-query-with-postgresql-wildcards-like-a-pro.md
            
            
              Created
              October 27, 2019 14:16
            
          
id
...
example_column
...


205
...
Mel
...


206
...
Melissa
...


207
...
Mel
...
id	...	example_column	...
...	...	...	...
205	...	Mel	...
206	...	Melissa	...
207	...	Mel	...
209	...	Emelio	...
...	...	...	...
	SELECT * FROM example_table
	WHERE example_column LIKE '%mel%'
	OR example_column LIKE '%Mel%';
	const name = "Melissa";
	const includesPattern = name.toLowerCase().includes("mel");
	console.log(includesPattern);

	// Outputs true
	const name = "Melissa";
	const includesPattern = name.includes("mel");
	console.log(includesPattern);

	// Outputs false
	const name = "Emilio";
	const includesPattern = name.includes("mel");
	console.log(includesPattern);
	const numbers = [1, 4, 9];
	const includesFour = numbers.includes(4);
	console.log(includesFour);
id	...	example_column	...
...	...	...	...
203	...	Max	...
205	...	Mel	...
207	...	Mel	...
...	...	...	...