SQL query will not match row

Hi Guys!

I have the following sql query, which will not match the example row below. Any ideas why?


select * from mytable where status='1' and cv_hide='0' and industry like '%a:2:{i:0;s:4:"1047";i:1;s:4:"1048";}%' order by cv_date desc 

Row it should match:


INSERT INTO `mytable` (`id`, `industry`, `cv_date`, `status`, `cv_hide`) VALUES
(14, 'a:4:{i:0;s:4:"1047";i:1;s:4:"1048";i:2;s:4:"1049";i:3;s:4:"1050";}', '2011-06-08 16:16:34', '1', '0');


part of your select looks for a “a:2”, which is not present in your inserted data…

Exactly.
Why should

industry like '%[B][COLOR="Red"]a:2[/COLOR][/B]:{i:0;s:4:"1047";i:1;s:4:"[B][COLOR="red"]1048";}[/COLOR][/B]%'

have to match

[B][COLOR="red"]a:4[/COLOR][/B]:{i:0;s:4:"1047";i:1;s:4:"[B][COLOR="red"]1048";i[/COLOR][/B]:2;s:4:"1049";i:3;s:4:"1050";}

?