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

33 votes346 views6 answers
Change column name in mysql
SQL
0 vote355 views1 answer
Dbms_output sql developer
SQL
0 vote350 views1 answer
Java mysql swing example
SQL
1 vote344 views1 answer
How to delete data from sql database in android
SQL
0 vote351 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote334 views4 answers
Best data type to represent money in mysql
SQL
0 vote386 views1 answer
How to find date from date table in sql
SQL
0 vote356 views1 answer
Where date major today mysql
SQL
50 votes401 views4 answers
Sql alter type of column
SQL
0 vote292 views1 answer
Now() -1 mysql
SQL