Advanced mysql search

[narcis010]

Hello,

Some time ago I read there was a query in mySQL that allowed you to make more sofisticated searches.

I mean not the typical LIKE it was a command that if someone searched for "hello world" and there was an entry which containde "hello little world" mySQL would return it as a valid result.

Please could anyone tell me which was that query? I've been unable to find it! :-(

Thanks a lot,

Narcís

[ultraslacker]

http://www.mysql.com/doc/en/Regexp.html

[narcis010]

http://www.ultradev-es.com/documento.asp?id=56

I've found it! It is in spanish but it is written in a plain way.

Very interesting!

[sanu]

i want some help here coz u ppl are talking about search
i am making a search script my problem is ..say there is 100 lines of content and the keyword match at 40 line how to display a result from that line or say from the keyword