Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Reporting with SQL!
You have completed Reporting with SQL!
Preview
Replacing parts of text is handy for privacy concerns, standardization or improving output.
To replace piece of strings of text in a larger body of text you can use the REPLACE() function.
SELECT REPLACE(<original value or column>, <target string>, <replacement string>) FROM <table>;
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
For example, you could highlight
the search term in search results
0:00
by adding code so
it appears bold in a web browser.
0:03
Or for privacy reasons you might want
to obfuscate e-mail addresses or
0:07
even help search for
non-standardized user input.
0:11
For example, if a user types in
their country code abbreviation
0:14
rather than their full country name.
0:18
Let's take a look at the replace function
now and an example on how to use it.
0:20
Here's the replace function.
0:27
Like the substring function, the replace
function takes more than one value.
0:28
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up