Search all fields in mySql

Question

I want to search all fields from tables tblproduct in MySQL database a given string, possibly using syntax as:

SELECT * FROM tblproduct WHERE * LIKE '%textbox%'

Is it possible to do something like this?

its Full Text search. And this question is already answered here http://stackoverflow.com/questions/3797906/mysql-query-for-searching-through-all-the-fields — Pratik Joshi, Aug 14 '15 at 05:57
`SELECT * FROM WHERE (CONVERT( USING utf8) LIKE '%textbox%' OR CONVERT( USING utf8) LIKE '%textbox%' OR .........` — Alive to die - Anant, Aug 14 '15 at 05:58
Check the technique shown in this answer: http://stackoverflow.com/questions/834912/sql-search-for-a-string-in-every-varchar-column-in-a-database — JorgeBPrado, Aug 14 '15 at 05:58

Deenadhayalan Manoharan · Accepted Answer · 2015-08-14T06:14:47.077

6

Try this..

concate fields to search whole table

Select * from tblproduct  where Concat(field1, '', field2, '', fieldn) like "%textbox%"

or

Using MATCH and AGAINST in mysql

SELECT * FROM tblproduct  WHERE MATCH (field1, field2, field3) AGAINST ('textbox')

edited Aug 14 '15 at 06:14

answered Aug 14 '15 at 06:00

1 Answers1