| id | ... | example_column | ... |
|---|---|---|---|
| ... | ... | ... | ... |
| 203 | ... | Max | ... |
| 205 | ... | Mel | ... |
| 207 | ... | Mel | ... |
| ... | ... | ... | ... |
Kevin Peters igeligel
🤷♀️
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const name = "Melissa"; | |
| const includesPattern = name.toLowerCase().includes("mel"); | |
| console.log(includesPattern); | |
| // Outputs true |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const name = "Melissa"; | |
| const includesPattern = name.includes("mel"); | |
| console.log(includesPattern); | |
| // Outputs false |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const name = "Emilio"; | |
| const includesPattern = name.includes("mel"); | |
| console.log(includesPattern); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const numbers = [1, 4, 9]; | |
| const includesFour = numbers.includes(4); | |
| console.log(includesFour); |
igeligel
/ how-to-query-with-postgresql-wildcards-like-a-pro.sql
Created
October 27, 2019 14:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM example_table WHERE example_column LIKE 'M__'; |
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 | ... |
igeligel
/ how-to-query-with-postgresql-wildcards-like-a-pro-4.sql
Created
October 27, 2019 14:15
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM example_table WHERE example_column LIKE 'Mel%'; |
igeligel
/ how-to-query-with-postgresql-wildcards-like-a pro-3.md
Created
October 27, 2019 14:14
| id | ... | example_column | ... |
|---|---|---|---|
| 205 | ... | Mel | ... |
| 207 | ... | Mel | ... |
igeligel
/ how-to-query-with-postgresql-wildcards-like-a pro-2.md
Created
October 27, 2019 14:13
| id | ... | example_column | ... |
|---|---|---|---|
| ... | ... | ... | ... |
| 203 | ... | Max | ... |
| 204 | ... | Michael | ... |
| 205 | ... | Mel | ... |
| 206 | ... | Melissa | ... |
| 207 | ... | Mel | ... |
| 208 | ... | Taylor | ... |
| 209 | ... | Emelio | ... |