jQuery – [attribute^=value] Selector
The [attribute^=value] selector selects every element with a specific attribute that starts with a value beginning with a specified string.
jQuery – [attribute*=value] Selector
The [attribute*=value] selector selects every element with a specific attribute that has a value containing a specified string even as part of another word.
jQuery – :contains() Selector
The :contains() selector selects elements containing a specified string directly within it or indirectly in a child, grandchild, etc. of the element.
jQuery – $().jquery Property
The $().jquery property returns a string containing the jQuery version number being used.
SQL – MySQL ASCII() Function
The MySQL ASCII() function returns the ASCII value for the specific character.
SQL – MySQL CHAR_LENGTH() Function
The MySQL CHAR_LENGTH() function returns the length of a string in characters.
SQL – MySQL CHARACTER_LENGTH() Function
The MySQL CHARACTER_LENGTH() function returns the length of a string in characters.
SQL – MySQL CONCAT_WS() Function
The MySQL CONCAT_WS() function adds two or more expressions together using a separator.
SQL – MySQL FIELD() Function
The MySQL FIELD() function returns the index position of a case-insensitive value in a list of values.
SQL – MySQL FIND_IN_SET() Function
The MySQL FIND_IN_SET() function returns the position of a string within a list of strings.
SQL – MySQL FORMAT() Function
The MySQL FORMAT() function formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places, and returns it as a string.
SQL – MySQL INSERT() Function
The MySQL INSERT() function inserts a string within a string at the specified position and for a certain number of characters.
SQL – MySQL INSTR() Function
The MySQL INSTR() function returns the position of the first occurrence of a case-insensitive string in another string.
SQL – MySQL LEFT() Function
The MySQL LEFT() function extracts a number of characters from a string, starting from left.
SQL – MySQL LOCATE() Function
The MySQL LOCATE() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL LPAD() Function
The MySQL LPAD() function left-pads a string with another string, to achieve a specified length.