display records of a specific year in php mysql -

i have system shows records year wise. have dropdown menu user selects year, , storing value in variable $year. when $year = 2013-2014, should not display records of year 2014-2015. btw when insert contractnumber, insert year user has selected during login. e.g. contractnumber = 1#2013-2014.

i tried queries:

select * contract contarctnumber rlike "^$year"; 

now when select year 2014-2015, still displays records year 2013-2014.

any suggestions?

try query

select * contract contarctnumber "%$year"; 

sqlfiddle demo

example

create table test (contarctnumber varchar(25)); insert test values ('1#2013-2014'), ('1#2014-2015'), ('2#2014-2015'); 

select query

select * test contarctnumber "%2014-2015"; 

output

| contarctnumber | ------------------ |    1#2014-2015 | |    2#2014-2015 |