<div>
Please tell us exactly what it is you are trying to do.
</div>


Please tell us exactly what it is you are trying to do.

<div>
You can't do that with a normal SELECT. &nbsp;In MySQL, most object names are not subject to wildcard expansion. &nbsp;There are two alternatives off the top of my head:<br />
<br />
1) Create a view based on a UNION of all the relevant tables, then SELECT from the view. <br />
2) Create a stored procedure which pulls the table names based on your wildcard selection, then dynamically creates a SELECT to pull from all the tables. &nbsp;<br />
<br />
The first one is easiest, especially in the context of future editing. &nbsp;The second is moderately better future-proofing. &nbsp;Generally, the fact that you have to worry about this and create work-arounds indicates a design problem.
</div>


You can't do that with a normal SELECT.  In MySQL, most object names are not subject to wildcard expansion.  There are two alternatives off the top of my head:

1) Create a view based on a UNION of all the relevant tables, then SELECT from the view.
2) Create a stored procedure which pulls the table names based on your wildcard selection, then dynamically creates a SELECT to pull from all the tables.  

The first one is easiest, especially in the context of future editing.  The second is moderately better future-proofing.  Generally, the fact that you have to worry about this and create work-arounds indicates a design problem.

<div>
<div class="content wysiwyg-content">
if have a wordpress website that uses mysql database. there is tables called wp_2_wcmp_products_map, wp_3_wcmp_products_map and so on<br />
<br />
i want to search all the tables with the same name something like this wp_%_wcmp_products_map how can i do this.
</div>
</div>


if have a wordpress website that uses mysql database. there is tables called wp_2_wcmp_products_map, wp_3_wcmp_products_map and so on

i want to search all the tables with the same name something like this wp_%_wcmp_products_map how can i do this.

how to use select tablename with wildcard

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.