0

I have a database table that I output on a website with a search field for each column and one global search field.

Im trying to figure out how to create a dynamic search in the global search field that combines the strings i add from all the columns. Is this possible?

My current query below. 

  SELECT flexstock.`SKU`,
           flexstock.`Partnr`,
           flexstock.`Manufacturer`,
           flexstock.`Description`,
           flexstock.`Status`,
           flexstock.`QTY`
    FROM flexstock
Jerry
  • 1,069
  • 2
  • 13
  • 31
  • Have you read [MySQL documentation](https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html) for full-text searches? – Zack Sep 26 '18 at 12:05
  • Possible duplicate of [Search in all fields from every table of a MySQL database](https://stackoverflow.com/questions/639531/search-in-all-fields-from-every-table-of-a-mysql-database) – Cid Sep 26 '18 at 12:06
  • I had a similar question not to long ago. https://stackoverflow.com/questions/49072765/fulltext-match-against-returning-empty-set – Jonny Sep 26 '18 at 12:22

0 Answers0