http://sqlzoo.net/w/index.php?title=REPLACE&feed=atom&action=history
REPLACE - Revision history
2013-05-25T17:32:24Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=REPLACE&diff=1393&oldid=prev
Connor at 15:22, 16 July 2012
2012-07-16T15:22:54Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:22, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[<del class="diffchange diffchange-inline">SUSTRING </del>|SUBSTRING function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">SUBSTRING </ins>|SUBSTRING function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[LEFT |LEFT function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[LEFT |LEFT function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[RIGHT |RIGHT function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[RIGHT |RIGHT function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=REPLACE&diff=1392&oldid=prev
Connor at 15:22, 16 July 2012
2012-07-16T15:22:45Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:22, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[SUBSTRING function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">SUSTRING |</ins>SUBSTRING function]]</li></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[LEFT function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">LEFT |</ins>LEFT function]]</li></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[RIGHT function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">RIGHT |</ins>RIGHT function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=REPLACE&diff=1202&oldid=prev
Connor at 11:52, 13 July 2012
2012-07-13T11:52:49Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 11:52, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><th colspan='3'>REPLACE(f)</th></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><th colspan='3'>REPLACE(f<ins class="diffchange diffchange-inline">, s1, s2</ins>)</th></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=REPLACE&diff=1201&oldid=prev
Connor at 11:52, 13 July 2012
2012-07-13T11:52:28Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 11:52, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><table align='right' border='1'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><caption>Compatibility</caption></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><th colspan='3'><del class="diffchange diffchange-inline">MIN</del>(f)</th></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><th colspan='3'><ins class="diffchange diffchange-inline">REPLACE</ins>(f)</th></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>ingres</td><td>Yes</td><td></td></tr></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=REPLACE&diff=1200&oldid=prev
Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>MIN(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td>..."
2012-07-13T11:50:29Z
<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>MIN(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td>..."</p>
<p><b>New page</b></p><div><table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<tr><th colspan='3'>MIN(f)</th></tr><br />
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>mysql</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>postgres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr><br />
</table><br />
<h1>REPLACE</h1><br />
<p>REPLACE(f, s1, s2) returns the string f with all occurances of s1 replaced with s2. </p><br />
<pre style='width:60ex'><br />
REPLACE('vessel','e','a') -> 'vassal'<br />
</pre><br />
<br />
<div class='qu'><br />
In this example you remove all the 'a's from the name of each country. <br />
This happens because the string 'a' is replaced with ''. <br />
<source lang='sql' class='def'><br />
SELECT name,<br />
REPLACE(name, 'a','')<br />
FROM bbc<br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[SUBSTRING function]]</li><br />
<li>[[LEFT function]]</li><br />
<li>[[RIGHT function]]</li><br />
</ul></div>
Connor