MySQL8 LOAD_FILE() Functions – String Functions
This function helps in reading a file and returns its contents as a string. Some most important part of the function To use this function, the file must be located...
Category: PHP
MySQL8 LOCATE() Functions – String Functions
LOCATE() Functions returns the position of the first instance of srchstring in string or the first instance after a given initial position in the string. Returns 0 if srchstring is...
How to use the LIKE Operator in MySQL8?
The LIKE operator performs pattern matching using an SQL pattern. If the string matches the pattern given, the result is 1(TRUE), otherwise it’s 0(FALSE). This is not necessarily to be...
Different ways to use RIGHT() Function in MySQL8.
RIGHT() function fetches a number of characters from a string, starting from right. How many characters will be fetched ? It is determined by second parameter i.e length. It will...
How to get the LENGTH() of string in MySQL8?
This function helps in getting the length of a string in bytes. LENGTH() functions returns the length of a string in bytes. A multibyte character counts as a multiple bytes....
MySQL8 LEFT() Functions – String Functions
MySQL LEFT() Functions: Syntax LEFT ( string, length ); MySQL LEFT() Functions: Description LEFT() function fetches a number of characters from a string, starting from left. It will return NULL,...
MySQL8 INSTR() Functions – String Functions
MySQL INSTR() Functions: Syntax INSTR ( string, srchstring ); MySQL INSTR() Functions: Description INSTR() Functions returns the position of the first instance of srchstring in string. This is the...
MySQL8 UNHEX() Functions – String Functions
MySQL UNHEX() Functions: Syntax UNHEX ( string ); MySQL UNHEX() Functions: Description UNHEX() Functions for a string argument, return value is a binary string. UNHEX() function for a string argument...
MySQL8 INSERT() Functions – String Functions
MySQL INSERT() Functions: Syntax INSERT ( string1, startpos, length, newstring ); MySQL INSERT() Functions: Description INSERT() Functions push newstring at specified place up to specified number of characters into existing...
MySQL8 HEX() Functions – String Functions
MySQL HEX() Functions: Syntax HEX ( string1 ); or HEX ( N ); string1 represents input as a string.N represents input as a number. MySQL HEX() Functions: Description Hex()...
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...
How to Check PHP is installed on ubuntu / linux or not ?
Open a shell terminal either by using the Ctrl+Alt+T keyboard shortcut or by clicking on the terminal icon. Now there are many possible ways to do this. Here are they...
Top 20 MySql Interview Question & Answers
MYSQL is the structured query language. It is the language to query the database. Here are some of the important questions being asked from beginners. Q1. What is MySQL? A1....
Cookies – PHP
What are cookies in PHP? Cookies are small files which are stored on user computers. Every time you visit a site on web browser a cookie file gets embed on...
vfprintf – PHP String Functions
Syntax : vfprintf ( stream_handle, string_format, argarray ); Description : vfprintf() function writes a formatted string to a stream. Stream specified by stream_handle. Works similar as fprintf() but accepts an array...
sscanf – PHP String Functions
Syntax : sscanf ( string, string_format, arg1, arg2, arg3… ); Description : The sscanf() function parses input from a string according to a string_format. Output will come according to the string_format....
soundex – PHP String Functions
Syntax : soundex ( string ); Description : soundex() function calculates the soundex key of str. This soundex function returns a string 4 characters long, starting with a letter. Note: It creates the same key...
similar_text – PHP String Functions
Syntax : similar_text ( string1, string2, percentage); Description : similar_text() function calculates the similarity between two strings with values and percentage. Note: The levenshtein() function is faster than the similar_text() function. However, the similar_text() function will...
sha1 – PHP String Functions
Syntax : sha1 ( string, raw_output ); Description : sha1() function calculates the sha1 hash of a string. Parameter : [table caption=”” width=”100%” colwidth=”15%|15%|15%|55%” colalign=”left|lef|lef|left”] Name, Required /Optional, Value Type, Description string...
sha1_file – PHP String Functions
Syntax : sha1_file ( filename, raw_output ); Description : sha1_file() function calculates the sha1 hash of the file specified by filename using the » US Secure Hash Algorithm 1, and returns that hash....