I am trying to query a specific table based on a user input, and want to query the table that contains that user input as the search\_id in the name. For example, the table names are structured as `run_000000_search_000000_lda_000000` and I want to get the table that has the same search\_id as the on they put in. 

I know when "LIKE" is used on the Where clause you can get a column with a specific string or int in the name. However, I have found nothing on using it with the "FROM" clause.

Specific hardcoded query for search\_id 50

```
SELECT *
FROM `run_000044_search_000050_lda_000366`;

```

In summary, how can I get the table that has the same search\_id as the one the user put in. Also trying to use the run and lda to form a full table name does not work because there is no noticeable pattern in between the 3 names.

I also can use dynamic sql but am not sure how to do it.