Hi,

please can you advice me how to make mysql query insensitive for lower/uper case? I mean it will delete all matching occurencies no matter if they are lower/uppercase..

DELETE FROM `phpbb_posts` WHERE `post_text` LIKE '%popsanger%' LIMIT 30;
My table is myISAM, utf8_bin

-----
Someone adviced that i need to convert table into utf8_general_ci (ci = case insensitive). It can be necessary to change also collation of the field i want to affect (post_text)..