Re: pattern matching (in text field)

2002-03-24 Thread Paul DuBois
At 17:02 + 3/24/02, julian haffegee wrote: >Hi all, > >I currently have > >$result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl >WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%' >AND title_id != '$myrow[title_id]'"); > >this works to an extent,

pattern matching (in text field)

2002-03-24 Thread julian haffegee
Hi all, I currently have $result = mysql_query ("SELECT title_id, title FROM documents_tbl, url_tbl WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%' AND title_id != '$myrow[title_id]'"); this works to an extent, but 'keywords' is a text field and if $temp is for exam