TEST the "MATCH" MySQL

carloncho — Fri, 08 Feb 2008 23:15:25 +0000

TEST the "MATCH" MySQL function. Is better than LIKe to perform a search

L3ZL1E — Tue, 18 Sep 2007 15:17:09 +0000

Thanks!

brady.k — Sun, 16 Sep 2007 04:01:25 +0000

(Sorry for the delay on this)

You can run a MySQL query using something like:

SELECT * FROM my_table WHERE the_field LIKE '%the_variable%'

'
Where 'the_variable' is what you're looking for, with the percent signs acting as wildcards, both before and after.

Or you can use a number of different search services... Nutch (http://lucene.apache.org/nutch/about.html) and Lucene (http://lucene.apache.org) both sit on top of Apache...

Or you can use something like Google Custom Search (http://www.google.com/coop/cse/)

... that's all I can think of right now. There are other things out there that exist between lying on top of the server, and a pure web-based application. Take a look around.

Kufr — Mon, 10 Sep 2007 07:14:21 +0000

Can you be a little more specific? Like search for a field in a database? Search for specific keywords on a site?