Get first 3 letters in sql

-- substr(string, start, [, length ])
SELECT substr('Hello World', 1, 3) ;      -- Hel
SELECT substr('Hello World', 4, 5) ;      -- lo Wo
SELECT substr('Hello World', 4);          -- lo World
SELECT substr('Hello World', -3);         -- rld

Get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Similar codes

0 vote136 views1 answer
Sql datediff month
SQL
4 votes89 views1 answer
And or sql order of operations
SQL
0 vote211 views1 answer
Add user mysql wordpress
SQL
2 votes126 views2 answers
Oracle no data found error code
SQL
0 vote163 views1 answer
Prisma transaction
SQL
0 vote137 views1 answer
Mysql default uuid
SQL
0 vote169 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote139 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote192 views1 answer
Replace null value within column mysql
SQL
-1 vote124 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL