I am annoyed. I cannot do as "select where like" statement in mysql. There's a nifty regex feature in php, but I'm being a custard head and doing it in perl. I deserve to suffer.
Anyway, take a look in the morning at fetchall_arrayref as the way to do what you're after, which is to check three or four letters of a potential field and return the rows that are "like" the three or four letters. (Wow, that's clear as mud...)
[]
static link
writebacks: 0 (writeback = trackback +/- comment)