Teachnique
      CourseRoadmaps
      Login

      HomeIntroductionFeaturesVersionsVariablesInstallationAdministrationPHP SyntaxNode.js SyntaxJava SyntaxPython SyntaxConnectionWorkbench

      Create DatabaseDrop DatabaseSelect DatabaseShow DatabaseCopy DatabaseDatabase ExportDatabase ImportDatabase Info

      Create UsersDrop UsersShow UsersChange PasswordGrant PrivilegesShow PrivilegesRevoke PrivilegesLock User AccountUnlock User Account

      Create TablesShow TablesAlter TablesRename TablesClone TablesTruncate TablesTemporary TablesRepair TablesDescribe TablesAdd/Delete ColumnsShow ColumnsRename ColumnsTable LockingDrop TablesDerived Tables

      QueriesConstraintsInsert QuerySelect QueryUpdate QueryDelete QueryReplace QueryInsert IgnoreInsert on Duplicate Key UpdateInsert Into Select

      Create ViewsUpdate ViewsDrop ViewsRename Views

      IndexesCreate IndexDrop IndexShow IndexesUnique IndexClustered IndexNon-Clustered Index

      Where ClauseLimit ClauseDistinct ClauseOrder By ClauseGroup By ClauseHaving ClauseAND OperatorOR OperatorLike OperatorIN OperatorANY OperatorEXISTS OperatorNOT OperatorNOT EQUAL OperatorIS NULL OperatorIS NOT NULL OperatorBetween OperatorUNION OperatorUNION vs UNION ALLMINUS OperatorINTERSECT OperatorINTERVAL Operator

      Using JoinsInner JoinLeft JoinRight JoinCross JoinFull JoinSelf JoinDelete JoinUpdate JoinUnion vs Join

      Unique KeyPrimary KeyForeign KeyComposite KeyAlternate Key

      TriggersCreate TriggerShow TriggerDrop TriggerBefore Insert TriggerAfter Insert TriggerBefore Update TriggerAfter Update TriggerBefore Delete TriggerAfter Delete Trigger

      Data TypesVARCHARBOOLEANENUMDECIMALINTFLOATBITTINYINTBLOBSET

      Regular ExpressionsRLIKE OperatorNOT LIKE OperatorNOT REGEXP Operatorregexp_instr() Functionregexp_like() Functionregexp_replace() Functionregexp_substr() Function

      Fulltext SearchNatural Language Fulltext SearchBoolean Fulltext SearchQuery Expansion Fulltext Searchngram Fulltext Parser

      Date and Time FunctionsArithmetic OperatorsNumeric FunctionsString FunctionsAggregate Functions

      NULL ValuesTransactionsUsing SequencesHandling DuplicatesSQL InjectionSubQueryCommentsCheck ConstraintsStorage EnginesExport Table into CSV FileImport CSV File into DatabaseUUIDCommon Table ExpressionsOn Delete CascadeUpsertHorizontal PartitioningVertical PartitioningCursorStored FunctionsSignalResignalCharacter SetCollationWildcardsAliasROLLUPToday DateLiteralsStored ProcedureExplainJSONStandard DeviationFind Duplicate RecordsDelete Duplicate RecordsSelect Random RecordsShow ProcesslistChange Column TypeReset Auto-IncrementCoalesce() Function

      Useful FunctionsStatements ReferenceQuick GuideUseful ResourcesDiscussion

      Feedback

      Submit request if you have any questions.

      Course
      String Functions

      MySQL Tutorial

      This SQL tutorial is structured for beginners to guide them from the foundational concepts to advanced data manipulation and querying techniques in SQL. By the end of this tutorial, you will have developed a robust understanding of SQL, equipping you with the knowledge to efficiently manage and analyze data across various database systems. This guide sets the stage for your growth into a skilled data professional, ready to tackle complex data challenges and contribute to the field of data analysis and database management.

      String Functions

      MySQL - String Functions

      MySQL string functions are used to manipulate the string values. The following table details the string functions that are available in the MySQL.
      Sr.No.
      Name & Description
      1
      ASCII()
      This function returns numeric value of left-most character.
      2
      BIN()
      This function returns a string representation of the argument.
      3
      BIT_LENGTH()
      This function returns length of argument in bits.
      4
      CHAR()
      This function returns the character for each integer passed.
      5
      CHAR_LENGTH()
      This function returns number of characters in argument.
      6
      CHARACTER_LENGTH()
      This function is a synonym for CHAR_LENGTH().
      7
      CONCAT()
      This function returns concatenated string.
      8
      CONCAT_WS()
      This function returns concatenate with separator.
      9
      ELT()
      This function returns string at index number.
      10
      EXPORT_SET()
      This function returns a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get an off string.
      11
      FIELD()
      This function returns the index (position) of the first argument in the subsequent arguments.
      12
      FIND_IN_SET()
      This function returns the index position of the first argument within the second argument.
      13
      FROM_BASE64()
      This function decodes a base-64 encoded string as a binary string.
      14
      INSERT()
      Inserts a substring at the specified position up to the specified number of characters.
      15
      INSTR()
      This function returns the index of the first occurrence of substring.
      16
      LCASE()
      Synonym for LOWER().
      17
      LEFT()
      This function returns the leftmost number of characters as specified.
      18
      LENGTH()
      This function returns the length of a string in bytes.
      19
      LOAD_FILE()
      This function is used to load the specified file.
      20
      LOCATE()
      This function returns the position of the first occurrence of substring.
      21
      LOWER()
      This function returns the argument in lowercase.
      22
      LPAD()
      This function returns the string argument, left-padded with the specified string.
      23
      LTRIM()
      This function is used to removes leading spaces from the given string.
      24
      MAKE_SET()
      This function returns a set of comma-separated strings that have the corresponding bit in bits set.
      25
      MID()
      This function returns a substring starting from the specified position.
      26
      OCT()
      This function returns a string representation of the octal argument.
      27
      OCTET_LENGTH()
      This function is a synonym for LENGTH().
      28
      ORD()
      If the leftmost character of the argument is a multi-byte character, returns the code for that character.
      29
      POSITION()
      This function is a synonym for LOCATE().
      30
      QUOTE()
      This function escapes the argument for use in an SQL statement.
      31
      REPEAT()
      This function returns the starting index of the substring matching given regular expression.
      32
      REPLACE()
      This function replaces the matched sub string with the replacement string and returns the result.
      33
      REVERSE()
      This function is used to reverse the characters in a string
      34
      RIGHT()
      This function returns the specified rightmost number of characters.
      35
      RPAD()
      This function is used to add padding to the right side of the string until it reaches the desired length.
      36
      RTRIM()
      This function is used to remove trailing spaces.
      37
      SOUNDEX()
      This function returns a soundex string.
      38
      SPACE()
      This function returns a string of the specified number of spaces.
      39
      STRCMP()
      This function is used to compare two given strings.
      40
      SUBSTR()
      This function returns the substring as specified.
      41
      SUBSTRING()
      This function returns the substring as specified.
      42
      SUBSTRING_INDEX()
      This function returns a substring from a string before the specified number of occurrences of the delimiter.
      43
      TO_BASE64()
      This function encodes a string value to base-64 string.
      44
      TRIM()
      This function is used to removes the leading and trailing spaces of the given string.
      45
      UCASE()
      This function is a synonym for UPPER().
      46
      UNHEX()
      This function converts each pair of hexadecimal digits to a character.
      47
      UPPER()
      This function is used to convert the characters in the given string to uppercase.
      48
      WEIGHT_STRING()
      This function returns the weight string value of the given argument.
      49
      MATCH
      This operator is used to search for particular string in the specified list of columns.
      50
      REGEXP
      This operator is similar to the REGEXP_LIKE() function it is used to match a particular pattern in the given string.
      51
      SOUNDS LIKE
      This operator is used to compare the soundex values of two strings.
      P