Node.js MySQL LPAD() Function Last Updated : 07 Oct, 2021 Comments Improve Suggest changes Like Article Like Report LPAD() Function is a Builtin function in MySQL which is used to attach a given string to text from left side till total length is equal to given value. If the given string is small then it is repeated multiple times. Syntax: LPAD(text, total_length, string) Parameters: LPAD() function accepts three parameters as mentioned above and described below. text: In this text value will be padded from left sidetotal_length: Total length of output stringstring: This string value will be padded from left side Return Value: LPAD() function returns a string by attaching value to text from left side till total length is equal to given value. If the value is small then it is repeated multiple times. 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"); // here is the query let query = `SELECT LPAD(' For Geeks', 23, 'Geeks') AS LPAD_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"); // here is the query let query = `SELECT name, LPAD(name, 20, 'Geek') AS LPAD_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 LTRIM() 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 LCASE() Function LCASE() function is a built-in function in MySQL that is used to convert all characters of a given string to lowercase. Syntax: LCASE(input_string)Parameters: It takes one parameter as follows: input_string: Input string which is passed as a parameter to convert this string to lowercase.Return Value 2 min read 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 2 min read Node.js MySQL LEFT() Function LEFT() Function is a Builtin function in MySQL which is used to get Prefix of a specific size of Given String. Syntax: LEFT(input_string, size_of_prefix) Parameters: LEFT() function accepts two parameters as mentioned above and described below. input_string: We will get prefix of this input stringsi 2 min read Node.js MySQL LOCATE() Function LOCATE() 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: LOCATE(pattern, text, starting_position) Parameters: LOCATE() function accepts three parameters as m 2 min read Node.js MySQL LTRIM() Function LTRIM() Function is a Builtin Function in MySQL which is used to trim all spaces from left side of input string. Syntax: LTRIM(string) Parameters: LTRIM() function accepts a single parameters as mentioned above and described below. string: String needed to be trimmed from left side Return Value: LTR 2 min read 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() 2 min read Like