如何在我的网站上进行搜索

Question

I wanted to add a search feature on a website that would allow users to search the whole website.

The site has around 20 tables and i wanted the search to search through all 20 tables.

Any one can point me into what sort of mysql queries I need to build?

Answer 1

First of all, what about adding custom Google websearch to your site?

The hard way: You should propably do a query for each of your tables and LIMIT (with LIKE on text columns or use full text indexing if your database software supports this) the result to X (e.g. ten) results. In your code, somehow rate these results and display the X best results.

You could also try to use a UNION of multiple queries but then the resulting tuples all have to same structure (if I remember correctly).