Question: ```
SELECT @sqlText = @sqlText + ' SELECT * FROM ' + QUOTENAME(name) + CHAR(13) FROM sys.tables

```

Answer: 
[![enter image description here](https://i.stack.imgur.com/206YC.png)](https://i.stack.imgur.com/206YC.png)If 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
You can't search like that. You can write a query as

```
SELECT * FROM tablename
WHERE MATCH(`col1`, `col2`, `col3`) AGAINST ('$searchword')

```