> > Depending on what character set you are using, it could be a problem > > but the fix is simple, UPPER(%s) or LOWER(%s) (based on how your data is > stored). > > I agree to dumping LIKE for performance reasons > > the tables are all UTF8, but there is no relevant non-ascii data i choosed > like > only for case-insensitivity thank you very much! >
You're welcome very much! I'll just scour back into my corner for now and just wait until you ask a similar question again in the future on why it's not working again. Then I can just cut and paste.
