How to search string from large size table

Question

I have a table employee with thousands data. I need search particular string from this table. How to write query for that Please help me Thanks in advance

Possibly related question [Extract a search string in context](http://stackoverflow.com/q/6221821/4519059) or [How can I manipulate MySQL fulltext search relevance to make one field more 'valuable' than another?](http://stackoverflow.com/q/547542/4519059) ;). — shA.t, Jul 03 '16 at 06:32

score 2 · Answer 1 · edited Jul 03 '16 at 06:31

2

Here's an example

SELECT field_name 
FROM table_name 
WHERE = 'value'

edited Jul 03 '16 at 06:31

shA.t

16,580
5
54
111

answered Jul 03 '16 at 06:27

Melchizedek

1,057
17
29

Mostafa Vatanpour · Answer 2 · 2016-07-03T07:08:05.237

If one (or possibly more) column has a bulk text you can use full-text search ability of mysql (5.6 and above) to do that. It will speed up search operation very much. The Documentation is here.

Sample:

CREATE TABLE articles ( 
  id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
  title VARCHAR(200), 
  body TEXT, 
  FULLTEXT (title,body) 
  ) ENGINE=InnoDB; 

SELECT id, title, body, 
  MATCH (title,body) AGAINST ('database' IN BOOLEAN MODE) AS score 
  FROM articles ORDER BY score DESC;

How to search string from large size table

2 Answers2