Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML and more.
SELECTSUBSTR("SQL Tutorial",5,3)ASExtractString; Try it Yourself » Definition and Usage The SUBSTR() function extracts a substring from a string (starting at any position). Note:The SUBSTR() andMID()functions equals to theSUBSTRING()function. ...
❮ MySQL Functions Example Right-pad the string with "ABC", to a total length of 20: SELECTRPAD("SQL Tutorial",20,"ABC"); Try it Yourself » Definition and Usage The RPAD() function right-pads a string with another string, to a certain length. ...
❮ MySQL Functions Example Replace "SQL" with "HTML": SELECTREPLACE("SQL Tutorial","SQL","HTML"); Try it Yourself » Definition and Usage The REPLACE() function replaces all occurrences of a substring within a string, with a new substring. ...
Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML and more.
❮ MySQL Functions Example Remove leading and trailing spaces from a string: SELECTTRIM(' SQL Tutorial ')ASTrimmedString; Try it Yourself » Definition and Usage The TRIM() function removes leading and trailing spaces from a string.
MySQL RTRIM() Function❮ MySQL FunctionsExampleRemove trailing spaces from a string:SELECT RTRIM("SQL Tutorial ") AS RightTrimmedString; Try it Yourself » Definition and UsageThe RTRIM() function removes trailing spaces from a string.SyntaxRTRIM(string)Parameter Values...
MySQL UPPER() Function❮ MySQL FunctionsExample Convert the text to upper-case: SELECT UPPER("SQL Tutorial is FUN!"); Try it Yourself » Definition and UsageThe UPPER() function converts a string to upper-case.Note: This function is equal to the UCASE() function....
❮ MySQL Functions ExampleGet your own SQL Server Extract a substring from a string (start at position 5, extract 3 characters): SELECTMID("SQL Tutorial",5,3)ASExtractString; Try it Yourself » Definition and Usage The MID() function extracts a substring from a string (starting at any...
MySQL UCASE() Function❮ MySQL FunctionsExample Convert the text to upper-case: SELECT UCASE("SQL Tutorial is FUN!"); Try it Yourself » Definition and UsageThe UCASE() function converts a string to upper-case.Note: This function is equal to the UPPER() function....