How to implement search functionality in SQL?

Question

How can I implement search functionality other than SQLQuery, Joins and conditional querys?

You should state what is your goal, then we can help with how it can be done. — Amirshk
– Amirshk, Commented Nov 24, 2009 at 5:34

x2. · Accepted Answer · 2009-11-24 05:36:17Z

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

answered Nov 24, 2009 at 5:36

x2.

9,6586 gold badges43 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lc. · Accepted Answer · 2009-11-24 05:36:26Z

0

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?

answered Nov 24, 2009 at 5:36

lc.

117k21 gold badges163 silver badges190 bronze badges

Comments

Paul Huff · Accepted Answer · 2009-11-24 05:41:29Z

0

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.

answered Nov 24, 2009 at 5:41

Paul Huff

1735 bronze badges

Collectives™ on Stack Overflow

How to implement search functionality in SQL?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related