Why does this query return too many results?

Question

I have a mysql query

Select * from tbl_schoolphotos where Filename like 
         'glasshouse_1_%' order by DateTaken

I would like to match

• glasshouse_1_20122204123455
• glasshouse_1_20122206102415

but not

• glasshouse_18_20122206102415

but its matching all three. Anyone know why? Does _ have special meaning in mysql?

Answer 1

Because the underscore matches any single character