Node.js MySQL POSITION() Function Last Updated : 07 Oct, 2021 Comments Improve Suggest changes Like Article Like Report 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 above and described below. pattern: Pattern to be Searchedtext: In this text, pattern will be searched Return Value: POSITION() function returns position of first occurrence of a pattern in a text when searched from specific position. If something went wrong it will return 0. Modules: mysql: To handle MySQL Connection and Queriesnpm install mysql SQL publishers Table Preview: Example 1: JavaScript 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 POSITION('for' IN 'GEEKSFORGEEKS') AS POSITION_Output`; db_con.query(query, (err, rows) => { if (err) throw err; console.log(rows); }); }); Output: Example 2: JavaScript 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 name, POSITION('a' IN name) AS POSITION_Output FROM publishers`; db_con.query(query, (err, rows) => { if (err) throw err; console.log(rows); }); }); Output: Comment More infoAdvertise with us Next Article Node.js MySQL POSITION() Function P pratikraut0000 Follow Improve Article Tags : Technical Scripter Web Technologies Node.js Technical Scripter 2020 NodeJS-MySQL +1 More Similar Reads Node.js MySQL SUBSTRING() Function 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 exec 2 min read 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 2 min read 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 2 min read 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 2 min read 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 2 min read Like