My brain may be really tired but I do not have to work on my head about this simple query. I want to remove a final substrings within the delimiter such as ',' from a column? I was thinking about using reverse or right .. but the results are being queued very oddly ...
Let's say I have a table column 'DESCRIPTION' in which There is a table law with entry "IT-X130E-10" from "IT-X130E-9" to converted laptop
and I final Substring want
IT-X130E-9 The '' 'within the delimiter is expected to clear it now
can try
SELECT SUBSTRING_INDEX (SUBSTRING_INDEX ('yourString', '' ', -2),' '', 1);
No comments:
Post a Comment