Fli
09-22-2013, 05:08 PM
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)..
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)..