[PHP + mySQL] searching the database

[dekuro]

anyone know a function (built-in) in PHP to search a mySQL table for a word or phrase? I know this bulletin board has a search function but how can I program this and make somekind of ranking for the results?

thanx

[aspen]

SELECT *
FROM TABLE
WHERE desiredcolumn like '%searchcriteria%'

Chris

[dekuro]

It works fine without problems, however not very precise...

for example the words: 'but', 'and', 'in' etc. are almost in every tip of the day. I know, one should search for such words, but can I somehow make the search more precise? When I entered a space (spacebar), all tips were shown which I hope to prevent.

thanks alot in advance!

[aspen]

Yes, that is very basic.

But many search functions work that way.

People will not be searching for "and" or "the" they'll be searching for more complicated words or phrases. If you type in "The" in lycos and you'll get a quarter of a billion results. The only way other search engines get around this is by simply denying the ability to search by such common single words.

As for the space, you can trim the search input and then do a check and see if it contains anything, if it does not don't let them search.


If you want them to be able to search for:

"White House" +carter -nixon

Then you're going to have to take the search input, parse it and break it into different variables, and then reconstruct your search statement.

Chris

[freddydoesphp]

I wrote one a while back, that checks for the existence of 'and' or 'or' in the serach string then builds the query accordingly while omitting those two words from the search. if you would like a copy of the code just email me at freddy@bereminded.com and I would be happy to give you a copy.