[thelist] msql: using an index to search across columns?

rudy rudy937 at rogers.com
Mon Sep 29 11:34:00 CDT 2003


hi dunstan

try this --

    select title, body 
      from blog_post 
     where concat(title,body) LIKE '%telegraph%'
       and concat(title,body) LIKE '%death%'

rudy



More information about the thelist mailing list