- What Are Functions? 3:12
- Adding Text Columns Together 3:39
- Single vs Double Quotes
- Concatenating Text 2 objectives
- Finding the Length of Text 2:50
- Getting the Length of a String 1 objective
- Changing the Case of Text Columns 2:45
- Changing Cases of Strings 2 objectives
- Creating Excerpts From Text 2:19
- Creating Excerpts 1 objective
- Replacing Portions of Text 1:58
- Replacing Strings 1 objective
- Practice Session 3:27
- Review: Working with Text 5 questions
Preview
Video Player
00:00
00:00
Replacing Portions of Text
1:58Replacing parts of text is handy for privacy concerns, standardization or improving output.
Another handy thing you can do is replace
portions of text with other text values.
0:00
This could be good for
adding styling to a web page.
0:05
For example, you could highlight
the search term in search results
0:08
by adding code so
it appears bold in a web browser.
0:12
Or for privacy reasons you might want
to obfuscate e-mail addresses or
0:16
even help search for
non-standardized user input.
0:20
For example, if a user types in
their country code abbreviation
0:23
rather than their full country name.
0:27
Let's take a look at the replace function
now and an example on how to use it.
0:29
Here's the replace function.
0:36
Like the substring function, the replace
function takes more than one value.
0:37
The first value is the column of
value that you want to replace.
0:43
You may want to replace either a part or
all of the text in that column.
0:48
Then the target string.
0:53
This is what you want to replace.
0:55
Finally, the string you want
to replace the target with.
0:57
Let's say in our addresses
table we have a state column
1:01
where the users could have
entered their own value.
1:06
We want to search all addresses
in the state of California.
1:09
For the sake of simplicity,
let's say there's only two values
1:13
that are entered in the state for
California, California and CA.
1:18
Let's replace all instances
of California with CA.
1:23
Now we can use this to search for
all addresses in California.
1:28
When we run this query,
we get all instances of California and
1:33
CA no matter how it was
inserted into the database.
1:38
Again, we're just using
the function in the condition.
1:43
We can use this function over
in the select portion, too.
1:47