fattahsafa has asked for the wisdom of the Perl Monks concerning the following question:
My tool reads words from files, manipulates them then insert them into mysql database. For example, I use the following queries:
my $insert_query = "INSERT INTO arabic_corpus (crps_word, crps_count) VALUES ('$word', '$count')";
the problem is that some words comes with single quote like "didn't". This makes a conflict with the quotes Surrounds the variables. Double quote can't also be used.
any suggestion to fix this?