Answers for "check string length in mysql query"

SQL
3

mysql string length

-- Relevant for MySQL only

-- syntax
LENGTH(<your-string>)

-- example
LENGTH('CountCharacters') -- OUTPUT: 15
        123456789012345

-- example with query 
SELECT 'CountCharacters',LENGTH('CountCharacters')
FROM DUAL;

-- OUTPUT: CountCharacters, 15
Posted by: Guest on May-08-2020
15

mysql length string

SELECT length('abcd') FROM DUAL;		-- Oracle
SELECT length('abcd');					-- MySql / PostGreSQL
SELECT len('abcd');						-- SQL Server
Posted by: Guest on May-04-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language