TRIM to remove Prefix and Suffix from a string

TRIM() removes spaces from both ends by default and can also remove a specified leading or trailing string. See LTRIM() and RTRIM() for one-sided whitespace removal.

SELECT TRIM( BOTH 'XX' FROM 'XXplus2net.comXXX') -- Output plus2net.comX

SELECT TRIM(BOTH 'XX' FROM 'XX.plus2net.com.XXX') -- Output .plus2net.com.X

SELECT TRIM(LEADING 'www.' FROM 'www.plus2net.com') -- Output plus2net.com

SELECT TRIM(LEADING 'XX' FROM 'XX.plus2net.com.XXX') -- Output .plus2net.com.XXX

SELECT TRIM(TRAILING 'com' FROM 'plus2net.com') -- Output plus2net.

SELECT TRIM(TRAILING 'XX' FROM 'XX.plus2net.com.XXX') -- Output XX.plus2net.com.X

SELECT TRIM(' plus2net.com ') -- Output is plus2net.com

Normalizing case before TRIM()

If you need predictable case-normalized trimming, apply UPPER() or LOWER() consistently to the removal string and the source string.

SELECT TRIM(BOTH 'XX' FROM 'xx.plus2net.com.XXX') -- Output xx.plus2net.com.X

SELECT TRIM(BOTH UPPER('XX') FROM UPPER('xx.plus2net.com.XXX')) -- Output  .PLUS2NET.COM.X

SELECT TRIM(BOTH LOWER('XX') FROM LOWER('xx.plus2net.com.XXX')) -- Output .plus2net.com.x 

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: