asked on MySQL query with substring
What is wrong with this:
SELECT * FROM `citrans` WHERE substring(dtstamp,0,4) = '2012'.
See attached for structure of table citrans.
There are hundreds of records with year = 2012.
citrans-str.jpg
SELECT * FROM `citrans` WHERE substring(dtstamp,0,4) = '2012'.
See attached for structure of table citrans.
There are hundreds of records with year = 2012.
citrans-str.jpg
MySQL Server
Last Comment
Kent Dyer
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
http://sqlfiddle.com/#!2/c00121/4