mysqlsqlcmd

SQL Syntax Problem: How do I get the first 4 letters and Uppercase

I am having a hard time getting the value in the database with a constraint of getting only the first 4 letters of the name as well as its in uppercase.

I am using MySQL on Command Prompt and so far I have tried this syntax and I always get this error,

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM STUDENTS' at line 1

The syntax I have tried;

SELECT UCASE(MID(NAME,1,3) FROM STUDENTS;

SELECT UPPER(SUBSTRING(NAME,1,3) FROM STUDENTS;

Tried all of them but I am still getting errors. Do you guys have any idea where I might be wrong?

Solution

  • you have just missed a closing parenthesis.

    SELECT UPPER(SUBSTRING(NAME,1,3)) FROM STUDENTS;

    Also, to get the first 4 letters you should use SUBSTRING(NAME,1,4)

    Cheers