Does MySql have any built in search functionality

From: lawrence (lkrubner_at_geocities.com)
Date: 04/30/04


Date: 29 Apr 2004 19:29:50 -0700

I've spent some time going over this page:

http://dev.mysql.com/doc/mysql/en/Data_Manipulation.html

And so far it seems the answer is no. So I thought I'd ask here. Does
anyone know of any built-in search algorithms with MySql?

I'm looking for a way to return the results of my last SELECT
statement (which uses LIKE) based on the number of hits the LIKE came
up with. In other words, I want something like this:

SELECT * FROM mainContent WHERE mainText LIKE '%$matchThis%' ORDER BY
number of matches per entry DESC



Relevant Pages

  • Re: OT: Computer problem
    ... > I spent an hour on the phone last night with SBC's tech support (two ... I can ping both sites from a DOS prompt. ... Check for an entry in your HOSTS file. ...
    (rec.gambling.poker)
  • Tracking working time with the EventLog
    ... I'd like to track the time I spent on the PC to the windows eventlog ... by writing an entry every 5 minutes. ...
    (microsoft.public.vb.winapi)
  • Tracking working time with the EventLog
    ... I'd like to track the time I spent on the PC to the windows eventlog ... by writing an entry every 5 minutes. ...
    (microsoft.public.scripting.jscript)
  • Re: - Man Made is created
    ... Wilba's entry is interesting. ... What color was the door and who ... spent the time to get the wax polished? ... guess I was looking for mane made right down to the base materials. ...
    (rec.photo.equipment.35mm)
  • Tracking working time with the EventLog
    ... I'd like to track the time I spent on the PC to the windows eventlog ... by writing an entry every 5 minutes. ...
    (microsoft.public.scripting.vbscript)