Node.js MySQL LTRIM() Function

Node.js MySQL LOWER() Function

Last Updated : 29 Nov, 2021

LOWER() Function is a Builtin function in MySQL which is used to convert all characters of given string to lowercase.

Syntax:

LOWER(input_string)

Parameters: LOWER() function accepts a single parameter as mentioned above and described below.

input_string: We will convert this string to lowercase

Return Value: LOWER() function returns a new lowercase string.

Modules:

mysql: To handle MySQL Connection and Queries

npm install mysql

SQL publishers Table Preview:

Database table

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 LOWER('This iNpUT strinG @!#$%^&*()?') AS lowercase_name";

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

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

Output:

Node.js MySQL LOWER() Function 1

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 LOWER(name) AS lowercase_name FROM publishers";

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

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

Output:

Node.js MySQL LOWER() Function 2

Node.js MySQL LTRIM() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

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

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

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

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

Node.js MySQL LENGTH() Function

LENGTH() Function is a Builtin function in MySQL which is used to get length of given string in bytes. Syntax: LENGTH(input_string) Parameters: LENGTH() function accepts a single parameter as mentioned above and described below. input_string: We will get number of characters of this string Return Va

Node.js MySQL LPAD() Function

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

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 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 GM lower() Function

The lower() function is an inbuilt function in the GraphicsMagick library which is used to create a pseudo-3D lowering effect of the image edges. The function returns the true value on success.Â Syntax: lower(width, height) Parameters: This function accepts two parameters as mentioned above and desc

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