-1
SELECT @sqlText = @sqlText + ' SELECT * FROM ' + QUOTENAME(name) + CHAR(13) FROM sys.tables
Suresh Kamrushi
  • 15,627
  • 13
  • 75
  • 90
Pradeep Rai
  • 1
  • This may be a duplicate of https://stackoverflow.com/questions/639531/search-in-all-fields-from-every-table-of-a-mysql-database – mweiss Nov 16 '17 at 05:49
  • See the link below. This may help you. [here] https://stackoverflow.com/questions/7950408/search-for-an-entry-in-a-database-without-specifying-a-column-name-table-nam – Saloni Nov 16 '17 at 06:43

2 Answers2

0

enter image description hereIf you are using phpmyadmin do the following steps:
1) select the database
2) Select search from the top links
3) Now you will get text box to enter what to search
4) Select the table in which you want to search. It will search whole database get the result

Suresh Kamrushi
  • 15,627
  • 13
  • 75
  • 90
-1

You can't search like that. You can write a query as

SELECT * FROM tablename
WHERE MATCH(`col1`, `col2`, `col3`) AGAINST ('$searchword')
Chidambaram
  • 434
  • 4
  • 14