Node.js MySQL UPPER() Function

Node.js MySQL SUBSTRING() Function

Last Updated : 17 Feb, 2021

SUBSTRING() function is a built-in function in MySQL that is used to get a substring of input string between given range inclusive.

Syntax:

SUBSTRING(input_string, from, length)

Parameters: It takes three parameters as follows:

input_string: It is the given string for which the substring will be executed.
from: The substring will be taken from this position.
length: It is the length of the substring.

Return Value: It returns a substring of input string between a given starting position and length. If length is out of string then the extra part is ignored.

Module Installation: Install the mysql module using the following command:

npm install mysql

Database: Our SQL publishers table preview with sample data is shown below:

Example 1:

index.js

const mysql = require("mysql");

let db_con  = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: '',
    database: 'gfg_db'
});

db_con.connect((err) => {
    if (err) {
      console.log("Database Connection Failed !!!", err);
      return;
    }

    console.log("We are connected to gfg_db database");

    // Notice the ? in query
    let query = `SELECT SUBSTRING("GeeksforGeeks", 
                 8, 20) AS SUBSTRING_Output`;

    db_con.query(query, (err, rows) => {
        if(err) throw err;

        console.log(rows);
    });
});

Run the index.js file using the following command:

node index.js

Output:

Example 2:

index.js

const mysql = require("mysql");

let db_con  = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: '',
    database: 'gfg_db'
});

db_con.connect((err) => {
    if (err) {
      console.log("Database Connection Failed !!!", err);
      return;
    }

    console.log("We are connected to gfg_db database");

    // Notice the ? in query
    let query = `SELECT SUBSTRING(name, 1, 4) 
            AS SUBSTRING_Name FROM publishers`;

    db_con.query(query, (err, rows) => {
        if(err) throw err;

        console.log(rows);
    });
});

Run the index.js file using the following command:

node index.js

Output:

Node.js MySQL UPPER() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

Node.js MySQL TRIM() Function

TRIM() function is a built-in function in MySQL that is used to trim all spaces from both sides of the input string. Syntax: TRIM(string)Parameters: It takes one parameter as follows: string: It is the string to be trimmed from both sides.Return Value: It returns string after trimming from both side

Node.js MySQL POSITION() Function

POSITION() Function is a Builtin Function in MySQL which is used to get position of first occurrence of a pattern in a text when searched from specific position. Note: It is not Case Sensitive. Syntax: POSITION(pattern IN text) Parameters: POSITION() function accepts two parameters as mentioned abov

Node.js MySQL SUM() Function

We use the SUM() function in MySQL to get Sum of the value of some columns. Syntax: SUM(column_name) Parameters: SUM() function accepts a single parameter as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the max value. Module Installation: Install the m

Node.js substr() function

The substr() function is a string function of Node.js which is used to extract sub-string from the given string. Syntax: string.substr(index, length) Parameters: This function accepts two parameters as mentioned above and described below: index: This parameter holds the starting index of the specifi

Node.js MySQL UPPER() Function

UPPER() function is a built-in function in MySQL that is used to convert all characters of a given string to uppercase. Syntax: UPPER(input_string)Parameters: It takes one parameter as follows: input_string: It is the given string that is passed for conversion to uppercase.Return Value: It returns a

Node.js MySQL UCASE() Function

UCASE() function is a builtin function in MySQL that is used to convert all characters of a given string to uppercase. Syntax: UCASE(input_string)Parameters: It takes one parameter as follows: input_string: It is the string that is passed for converting this string to uppercase.Return Value: It retu

Node.js MySQL MID() Function

MID() Function is a Builtin Function in MySQL which is used to get substring of input string between given range inclusive. Syntax: MID(input_string, from, length) Parameters: MID() function accepts three parameters as mentioned above and described below. input_string: Substring of this input will b

Node.js MySQL FIND_IN_SET() Function

FIND_IN_SET() function is a built-in function in MySQL that is used to get the position of the first occurrence of value string in a list of strings separated by comma(','). Syntax: FIND_IN_SET(value, list_of_string)Parameters: It takes two parameters as follows: value: It is the value to be searche

Node.js MySQL Min() Function

We will be using Min() function in MySQL to get Minimum value from some particular column. Syntax: MIN(column_name) Parameters: MIN() function accepts a single parameter as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the min value. Return Value: MIN()

Node.js MySQL AVG() Function

We use AVG Function to get the average value of all rows in the given column of MySQL Table. Syntax: AVG([column_name]) Parameters: AVG() function accepts a single parameter as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the average value. Module Inst