search functionality

Question

How can i implement search functionality otherthan sqlquery,joins and conditional querys

Answer 1

The simpliest way is to use like condition:

select * from Table where fieldName like '%searchword%'

But it's very slow, so it's better to use full-text indexing: in mysql, in sql server

Answer 2

Well, outside of SQL, you're left to the calling application to do searches. Definitely not the recommended choice if you can avoid it as you'll have to read all data first before searching it; indexing is a very powerful feature for databases.

If you want to display all data and then manipulate/sort/filter it, however, this method has its place.

Perhaps you wish to clarify your question as to what you're looking to accomplish?

Answer 3

It's better to use something like sphinx or solr to implement a real search engine rather than using things that most databases provide, even mysql's full-text search.