Substring reurns a number value instead of varchar
===



$query = mysql_query(SELECT * FROM test WHERE SUBSTRING(date,0,4)="1392") //for example 1392
echo query['name'];

i want to get 4 frist charachter and chek its equal with 1392 or not .
 but its return 1054 my column name type  is varchar and i have no idea about this ; 