houssam_ballout Posted July 9, 2007 Share Posted July 9, 2007 Hello all,I'd a website and a database which held the data of that site,I am building a web page for the search on that site, how can I do that?for example, if one entered anything in the search engine, I would like to search the whole database for that word?Thanks in advance Link to comment Share on other sites More sharing options...
zppblood Posted July 13, 2007 Share Posted July 13, 2007 http://w3schools.com/sql/sql_where.aspMake sure to look at the LIKE condition. Link to comment Share on other sites More sharing options...
Skemcin Posted July 13, 2007 Share Posted July 13, 2007 To elaborate on what mma_fighter123 points out is that you will have to decide what fields in which tables you would like to search in. Ideally, these tables would be index on the server to enhance performance. Use a stored procedure to build a temp table so as you go through each of your tables you can consolidate the results. Once you've gone through all the fields in all the tables, then you select the results of that and you're all set. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.