SELECT * FROM Grade_Theory WHERE 'The funcdamental particle is called a quark, Bob!' LIKE '%'||Answer||'%'

##</code><code>##

SELECT * FROM Grade_Theory

##</code><code>##

SELECT RowID, Question,Answer
  FROM Grade_Theory

##</code><code>##

my @words = split /\W+/, 'The funcdamental particle is called a quark, Bob!';
my @parts = ();
for (@words) {
  push @parts, "Answer like '%$_%'";
}
my $where_clause = join (" or\n",@parts);

my $sql = "SELECT RowID, Question,Answer
             FROM Grade_Theory
            WHERE $where_clause";

print "$sql\n";

##</code><code>##

SELECT RowID, Question,Answer
             FROM Grade_Theory
            WHERE Answer like '%The%' or
Answer like '%funcdamental%' or
Answer like '%particle%' or
Answer like '%is%' or
Answer like '%called%' or
Answer like '%quark%' or
Answer like '%Bob%'

##</code><code>##

my @words = split /\W+/, 'The funcdamental particle is called a quark, Bob!';
my @long_words=();
for (@words) {
  push @long_words, $1 if (/^(\w{3,})$/);
}
my @parts = ();
for (@long_words) {
  push @parts, "Answer like '%$_%'";
}
my $where_clause = join (" or\n",@parts);

my $sql = "SELECT RowID, Question,Answer
             FROM Grade_Theory
            WHERE $where_clause";

print "$sql\n";

##</code><code>##

SELECT RowID, Question,Answer
             FROM Grade_Theory
            WHERE Answer like '%The%' or
Answer like '%funcdamental%' or
Answer like '%particle%' or
Answer like '%called%' or
Answer like '%quark%' or
Answer like '%Bob%'