MySQL Substring return empty value

Asked 2011-12-05T14:16:59.980

SELECT SUBSTRING(FieldName,0,20) FROM Table

I try on phpmyadmin and returned empty value. How i use this function ?

mysql substring

Edit Report

1 Answer

you must use SELECT SUBSTRING(FieldName,1,20) FROM Table, because from 0 is 0 :)

use 1

ups, someone wrote answer faster than I :)

answered 2011-12-05T14:20:01.387