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 and I final Substring want The '' 'within the delimiter is expected to clear it now can try converted laptop
IT-X130E-9
SELECT SUBSTRING_INDEX (SUBSTRING_INDEX ('yourString', '' ', -2),' '', 1);
No comments:
Post a Comment