Substring () for fields in MYSQL

Question

I do not understand why this did not work:

select id,name,concat(substring(description,0,30),'...') as desc_shortened, created_date,added_by from products 

Even if there is data inside the description field. I have not seen any example fields in mySQL documentation. They used blank rows instead of column names.

concat(susbtring(description,0,30)) returns only ... and that’s it.

Answer 1

Use substring(description,1,30) instead.

Answer 2

Oracle treats 0 as 1 in this function, but mysql treats 0 as empty.To you should use a substring (description, 1.30).