Got this fixed. Tried this query.
mysql> select * from image where img_name like "%JohnMcGraw.jpg";
1 row in set (0.01 sec)
mysql> select * from image where img_name like "JohnMcGraw.jpg%";
1 row in set (0.00 sec)
mysql> select * from image where img_name like "JohnMcGraw.jpg";
0 row in set.
So there was some funkiness going on with the img_name column. I did the
following and it was fixed.
First I dumped the image table.
mysql> alter table image add column img_name2 varchar(255);
mysql> update image set img_name2=img_name;
mysql> select * from image where img_name2 like "JohnMcGraw.jpg";
1 row in set (0.00 sec
mysql> update image set img_name=img_name2;
mysql> alter table image drop column img_name2;
And that took care of it.
Thank you for the help.
--
Sean Forman
President, Sports Reference LLC
http://www.sports-reference.com/