I read the column about: Slapping together a search engine
I was wondering if you can change this:
SELECT count(search_table.word) as score, search_table.qid,your_table.blob
FROM search_table,your_table
WHERE your_table.qid = search_table.qid AND search_table.word
IN($querywords)
GROUP BY search_table.qid
ORDER BY score DESC";
into something with LIKE statements.
so my question: How can i use a "array" in LIKE statements?
thnx
I was wondering if you can change this:
SELECT count(search_table.word) as score, search_table.qid,your_table.blob
FROM search_table,your_table
WHERE your_table.qid = search_table.qid AND search_table.word
IN($querywords)
GROUP BY search_table.qid
ORDER BY score DESC";
into something with LIKE statements.
so my question: How can i use a "array" in LIKE statements?
thnx