Node.js MySQL INSERT() Function

Node.js MySQL FIND_IN_SET() Function

Last Updated : 17 Feb, 2021

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 searched.
list_of_string: It is the list of strings separated by comma (',').

Return Value: It returns the position of first occurrence of value string in a list of string separated by comma (',')

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");

    // Here is the query
    let query = "SELECT FIND_IN_SET('2', '1,12,2,32') AS 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: Advance Example

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");

    // Here is the query
    let sub_query = 
"(SELECT GROUP_CONCAT(name) FROM publishers)";

    let main_query = 
`SELECT FIND_IN_SET('lily', ${sub_query}) AS lily_position`;

    db_con.query(main_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 INSERT() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

Node.js MySQL FIELD() Function

FIELD() function is a built-in function in MySQL that is used to get the position of the first occurrence of a value in a set of expressions. In the case of string values, it is not case-sensitive. Syntax: FIELD(value, input_1, input_2, input_3, ...)Parameters: It takes two parameters as follows: va

Node.js MySQL INSTR() Function

INSTR() function is a built-in function in MySQL that is used to get the position of the first occurrence of pattern in the text. Note: In NodeJs MySQL, INSTR() function is not case sensitive. Syntax: INSTR(text, pattern)Parameters: It takes two parameters as follows: text: It is the given text in w

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 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 MySQL INSERT() Function

INSERT() function is a built-in function in MySQL that is used to insert a string into another string at some position after deleting some characters from it. Syntax: INSERT(string_1, position, number_of_characters_to_delete, string_2)Parameters: It takes four parameters as follows: string_1: It is

Node.js MySQL CONCAT_WS() Function

CONCAT_WS() function is a built-in function in MySQL that is used to concatenate a set of strings with a commonly given separator. Syntax: CONCAT_WS(separator, string_1, string_2, ...)Parameters: It takes two parameters as follows: separator: This separator will be used to concatenate strings.string

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 Count() Function

We use the COUNT() function in MySQL to count a number of rows in a column satisfying the WHERE clause. Syntax: COUNT([column_name]) Parameters: COUNT() function accepts a single parameter as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the count value

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