MySQL XML Sass Icons RWD Graphics SVG Canvas Raspberry Pi CyberSecurity Colors Git Matplotlib NumPy Pandas SciPy ASP AngularJS AppML Go TypeScript Django MongoDB Statistics Data Science PostgreSQL HowTo Code Game Spaces Typing Speed Excel DSA - DataStructures andAlgorithms ...
❮ MySQL Functions ExampleGet your own SQL Server Extract a substring from a string (start at position 5, extract 3 characters): SELECTSUBSTR("SQL Tutorial",5,3)ASExtractString; Try it Yourself » Definition and Usage The SUBSTR() function extracts a substring from a string (starting at...
❮ 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 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. ...
MySQLRPAD()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 FIND_IN_SET() Function❮ MySQL FunctionsExampleSearch for "q" within the list of strings:SELECT FIND_IN_SET("q", "s,q,l"); Try it Yourself » Definition and UsageThe FIND_IN_SET() function returns the position of a string within a list of strings....
PHP MySQLi PHP Network PHP Output Control PHP RegEx PHP SimpleXML PHP Stream PHP String PHP Variable Handling PHP XML Parser utf8_decode() utf8_encode() xml_error_string() xml_get_current_byte_index() xml_get_current_column_number() xml_get_current_line_number() xml_get_err...
MySQLLEFT()Function ❮ MySQL Functions Example Extract 3 characters from a string (starting from left): SELECTLEFT("SQL Tutorial",3)ASExtractString; Try it Yourself » Definition and Usage The LEFT() function extracts a number of characters from a string (starting from left). ...
❮ 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 CURRENT_DATE() Function❮ MySQL FunctionsExampleReturn the current date:SELECT CURRENT_DATE(); Try it Yourself » Definition and UsageThe CURRENT_DATE() function returns the current date.Note: The date is returned as "YYYY-MM-DD" (string) or as YYYYMMDD (numeric)....