INSTR(str, substr) / LOCATE(substr, str) / POSITION(substr IN str) Select FirstName, LastName, INSERT(LastName, 3, 20, FirstName) as LoginID from Personġ1. Replaces the sub-string starting at position pos and of length len in the string str with newstr. Select FirstName, HEX(FirstName) from Person Returns a hexadecimal equivalent of the string str. Select FORMAT(Phone, 0) as Phone from Person Select FirstName, LastName, FIELD('John', FirstName, LastName) as IsJohn from Personįormats the number X to ‘#,#,#.#’ for display. Returns the index position of string str amongst str1 to strn. Select FirstName, LastName, CONCAT_WS(', ', LastName, FirstName) as DisplayName from Person Select FirstName, LastName, CONCAT_WS(' ', FirstName, LastName) as DisplayName from Person Returns a concatenated string separated by a separator. Select FirstName, LastName, CONCAT(FirstName, LastName) as DisplayName from Person
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |