MySQL LENGTH() Function Last Updated : 10 Jun, 2024 Summarize Comments Improve Suggest changes Share Like Article Like Report MySQL LENGTH() function returns the length of a string in bytes. SyntaxThe MySQL LENGTH function syntax is: LENGTH(string) ParametersThe LENGTH function accepts only one parameter. string: A specified string whose length is to be counted.MySQL LENGTH() Function ExamplesLet's look at examples of the LENGTH function in MySQL. Query: SELECT LENGTH("GEEKSFORGEEKS");Output : 13Now we will use the LENGTH() function and find the length of all the float values. Query: CREATE TABLE float061( user_id int NOT NULL AUTO_INCREMENT,float_val float,PRIMARY KEY(user_id));INSERT float061(float_val) VALUES (1.9);INSERT float061(float_val) VALUES (1.1);INSERT float061(float_val) VALUES (3.9);INSERT float061(float_val) VALUES (10.2);INSERT float061(float_val) VALUES (7.9);SELECT LENGTH(float_val) FROM float061;Output : | LENGTH(float_val)| ----------------------------- | 3 | ----------------------------- | 3 | ----------------------------- | 3 |----------------------------- | 4 |----------------------------- | 3 |Using LENGTH() function and getting the length of the item given. Query: CREATE TABLE package099( user_id int NOT NULL AUTO_INCREMENT,item VARCHAR(10),mrp int,PRIMARY KEY(user_id));INSERT package099(item, mrp) VALUES ('books', 350);SELECT LENGTH(item) FROM package099;Output : 5 Comment More infoAdvertise with us Next Article MySQL LENGTH() Function N nidhi1352singh Follow Improve Article Tags : SQL Databases DBMS-SQL mysql Similar Reads SQL Interview Questions Are you preparing for a SQL interview? SQL is a standard database language used for accessing and manipulating data in databases. It stands for Structured Query Language and was developed by IBM in the 1970's, SQL allows us to create, read, update, and delete data with simple yet effective commands. 15+ min read SQL Tutorial Structured Query Language (SQL) is the standard language used to interact with relational databases. Whether you want to create, delete, update or read data, SQL provides the structure and commands to perform these operations. SQL is widely supported across various database systems like MySQL, Oracl 8 min read SQL Commands | DDL, DQL, DML, DCL and TCL Commands SQL commands are crucial for managing databases effectively. These commands are divided into categories such as Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), Data Query Language (DQL), and Transaction Control Language (TCL). In this article, we will e 7 min read SQL Joins (Inner, Left, Right and Full Join) SQL joins are fundamental tools for combining data from multiple tables in relational databases. Joins allow efficient data retrieval, which is essential for generating meaningful observations and solving complex business queries. Understanding SQL join types, such as INNER JOIN, LEFT JOIN, RIGHT JO 5 min read Normal Forms in DBMS In the world of database management, Normal Forms are important for ensuring that data is structured logically, reducing redundancy, and maintaining data integrity. When working with databases, especially relational databases, it is critical to follow normalization techniques that help to eliminate 7 min read SQL Query Interview Questions SQL or Structured Query Language, is the standard language for managing and manipulating relational databases such as MySQL, Oracle, and PostgreSQL. It serves as a powerful tool for efficiently handling data whether retrieving specific data points, performing complex analysis, or modifying database 15+ min read CTE in SQL In SQL, a Common Table Expression (CTE) is an essential tool for simplifying complex queries and making them more readable. By defining temporary result sets that can be referenced multiple times, a CTE in SQL allows developers to break down complicated logic into manageable parts. CTEs help with hi 6 min read Window Functions in SQL SQL window functions are essential for advanced data analysis and database management. It is a type of function that allows us to perform calculations across a specific set of rows related to the current row. These calculations happen within a defined window of data and they are particularly useful 6 min read Top 60 DBMS Interview Questions with Answers for 2025 A Database Management System (DBMS) is the backbone of modern data storage and management. Understanding DBMS concepts is critical for anyone looking to work with databases. Whether you're preparing for your first job in database management or advancing in your career, being well-prepared for a DBMS 15+ min read SQL | WITH Clause SQL queries can sometimes be complex, especially when you need to deal with multiple nested subqueries, aggregations, and joins. This is where the SQL WITH clause also known as Common Table Expressions (CTEs) comes in to make life easier. The WITH Clause is a powerful tool that simplifies complex SQ 6 min read Like