Hi

I have a piece of code which will search a series of records for the presence 
of two keywords $key1
and $key2 (see below)

The client now wants more keywords $key1,2,3,4 etc

But is there any alternative to mushrooming the the following select???

$wherekeyword =<<<__SQL__
   and
   (
   (
   (synopsis like '%$key1%') or
   (title    like '%$key1%') or
   (keywords like '%$key1%')
   )
   and
   (
   (synopsis like '%$key2%') or
   (title    like '%$key2%') or
   (keywords like '%$key2%')
   )
   )
__SQL__;
}
-- 
zzapper
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
http://www.rayninfo.co.uk/tips/ vim, zsh & success tips


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to