MySQL LOCATE() returns the position of the first occurrence of a string within a string. Both of these strings are passed as arguments. An optional argument may be used to specify from which position of the string (i.e. string to be searched) searching will start. If this position is not mentioned, searching starts from the … Read more
Description: MySQL LENGTH() returns the length of a given string. Syntax: LENGTH (str) Argument: Name Description str A string whose length is to be returned. Example of MySQL LENGTH() function mysql> SELECT LENGTH(NULL); Result: NULL mysql> SELECT LENGTH(”); Result: 0 mysql> SELECT LENGTH(‘ ‘); Result: 1 mysql> SELECT … Read more
MySQL CONCAT function is used to concatenate two strings to form a single string. Description: MySQL CONCAT() function is used to add two or more strings. There may be one or more arguments. Returns the string that results from concatenating the arguments. Returns a non binary string, if all arguments are non binary strings. Returns … Read more