mysql

MySQL UCASE() Functions – String Functions

MySQL UCASE() Functions: Syntax UCASE ( string ); MySQL UCASE() Functions: Description UCASE() functions convert all the characters in a string to uppercase characters according to the current character set...

mysql

MySQL UPPER() Functions – String Functions

MySQL UPPER() Functions: Syntax UPPER ( string ) MySQL UPPER() Functions: Description UPPER() functions convert all the characters in a string to uppercase characters according to the current character set...

mysql

MySQL CONCAT_WS() Functions – String Functions

MySQL CONCAT_WS() Functions: Syntax CONCAT_WS ( separator, string1, string2, .. stringN) MySQL CONCAT_WS() Functions: Description CONCAT_WS() functions returns the concatenated string and adds a separator between each of the concatenated...

HTML5 tutorial for beginners

List of all HTML Tags with Examples

HTML Tags: Tags are the basic elements of HTML structure. They define the purpose and function of things we can manage with them. There have been five official versions of...

HTML5 tutorial for beginners

Everything You need to Know about HTTP Codes List

Hypertext Transfer Protocol (HTTP) acts as the main foundation for sharing information through the internet. When the user view content from any websites server sends several codes or message about...

ALign Images in Div in HTML

Inline CSS Style

Inline CSS or Internal CSS In writing code for web, HTML and CSS are the foremost basic combination. HTML provides the structure while CSS fills out to represent them in...

mysql

MySQL CONCAT() Functions – String Functions

MySQL CONCAT() Functions: Syntax CONCAT ( string1, string2, ..  ) MySQL CONCAT() Functions: Description CONCAT() functions returns the concatenated string. You may have one or more arguments. If all arguments...

mysql

MySQL CHARACTER_LENGTH() Functions – String Functions

MySQL CHARACTER_LENGTH() Functions: Syntax CHARACTER_LENGTH ( string ) MySQL CHARACTER_LENGTH() Functions: Description This function is equal to the CHAR_LENGTH() function. Related articles : CHAR_LENGTH() , BIT_LENGTH(), LENGTH() See all MySQL...

mysql

MySQL CHAR_LENGTH() Functions – String Functions

MySQL CHAR_LENGTH() Functions: Syntax CHAR_LENGTH ( string ) MySQL CHAR_LENGTH() Functions: Description CHAR_LENGTH() functions returns the length of a string (in characters). A multibyte character counts as a single character....

mysql

MySQL CHAR() Functions – String Functions

MySQL CHAR() Functions: Syntax CHAR ( N,… [USING charset_name]) MySQL CHAR() Functions: Description CHAR() functions interpret each argument N as an integer and return a string consisting of the characters...

mysql

MySQL 8 String Functions ( Full List )

MySQL 8 has many built-in functions. This reference contains string functions in MySQL. [table caption=”MySQL 8 String Functions list with examples” width=”100%” colwidth=”10%|90%” colalign=”left|left”] Command, Description ASCII(), This will return...

mysql

MySQL BIT_LENGTH() Functions – String Functions

MySQL BIT_LENGTH() Functions: Syntax BIT_LENGTH ( string ); MySQL BIT_LENGTH() Functions: Description BIT_LENGTH() returns the length of the string passed as input in bits. MySQL BIT_LENGTH() Functions: Parameter [table caption=””...

mysql

MySQL ASCII() Functions – String Functions

MySQL ASCII() Functions: Syntax ASCII ( string ); MySQL ASCII() Functions: Description ASCII() function return the numeric value of left-most character. ASCII() works for 8-bit characters. MySQL ASCII() Functions: Parameter...

mysql

MySQL BIN() Functions – String Functions

MySQL BIN() Functions: Syntax BIN ( number ); MySQL BIN() Functions: Description BIN() function return a string containing binary representation of a number. Returns a string representation of the binary...