How to search table names in MySQL?

Question

Could anybody give me a little advice as to how I would search the table names from 1 database within a SQL PHP query.

At present this is my not working code.

I have a database named classified with a list of genres ie computers clothes cars music etc etc. Within each table is. I'd name price etc etc. I have all that processing correctly and I can use the data in my webpage but I'm a little stuck on the searching. Here's my query code:

Select * from $dbname WHERE $results LIKE '%$search%'

A database or table? Where is your code? – chris85 Aug 27 '17 at 06:09 — chris85, Aug 27 '17 at 06:09
What do you mean by not working? Error? – Sander bakker Aug 27 '17 at 06:51 — Sander bakker, Aug 27 '17 at 06:51

score 1 · Answer 1 · answered Aug 27 '17 at 03:36

1

Try this:

SELECT
    * 
FROM
    sys.tables 
WHERE
    name
LIKE
    '%product%'

answered Aug 27 '17 at 03:36

joe

31
8

or are you asking how to use that query? – joe Aug 27 '17 at 03:38
My query dont work. That's just expressing what I'm trying to do.. Use the list of genres in the dbname to search. – russbaker2016 Aug 27 '17 at 04:11

score 0 · Answer 2 · answered Aug 27 '17 at 07:01

If you are trying to perform a full database search to find out a data you can easily use MySql workbench or PhpMyAdmin to search data from your database. Also there are many open posts on StackOverflow regarding this issues. Please read the answer from this question.

How to search table names in MySQL?

2 Answers2