September 3rd, 2000, 03:15 PM
What is the SQL statement to do a keyword search using mySQL and Perl DBI??
For some reason the following is NOT functioning like a keyword search, but rather only retrieves a row if it is an EXACT match.
# not functioning
$statement = "SELECT query FROM graphics WHERE query LIKE $quotedString";
so whats the deal??? help me out please.
September 4th, 2000, 12:56 AM
I think you need to append and prepend the % wildcard
$statement = "SELECT query FROM graphics WHERE query LIKE %$quotedString%";