Only show tables with certain patterns in mysql "show tables"

mysql pagination show
user398384 picture user398384 · Aug 4, 2010 · Viewed 20.1k times · Source

There are too many tables in a db. how can I only show tables with certain patterns? Or is there a way I can do paging like "| more" in shell command?

Answer

a'r picture a'r · Aug 4, 2010 
show tables like 'pattern';

Related questions

How can I select rows in MySQL starting at a given row number?

Say I have 50 rows in a MySQL table. I want to select the first ten (LIMIT 10), but then I want to be able to select the next 10 on a different page. So how do I start my selection, after row 10? …

Read More
Limit pagination page number

$objConnect = mysql_connect("localhost","root","") or die(mysql_error()); $objDB = mysql_select_db("Test"); $strSQL = "SELECT * FROM UserAddedRecord WHERE (Name LIKE '%".$getname."%' and State LIKE '%".$getstate."%' and Cell LIKE '%".$getcell."%' and Custgroup LIKE '%".$…

Read More
Laravel join queries AS

Any way of defining an AS for a query?? I have tried the following: $data = News::order_by('news.id', 'desc') ->join('categories', 'news.category_id', '=', 'categories.id') ->left_join('users', 'news.user_id', …

Read More