Replacing a string

4 posts
[expired user #8308]'s profile image [expired user #8308] posted 9 years ago in Running SQL scripts Permalink
Hi all,

I prepared a selection:

SELECT TRIM(TRAILING SUBSTRING_INDEX(artist, ' ', -2) FROM artist) FROM tbldetail

This command will trim a string.

What I need is that the command not only trims but also deletes.

How can I do that?

Thanks,

Sebastiaan.

Please login to leave a reply, or register at first.