Portal Home > Knowledgebase > Articles Database > Show tables not like "this%"
Show tables not like "this%"
Posted by Syphic, 08-08-2008, 11:30 AM |
I am trying to get all tables which are not equal to this
Error occurs when i do the below
Example:
SHOW TABLES IN table NOT LIKE 'z\_%'
|
Posted by JustinSmall, 08-08-2008, 12:46 PM |
We would need to see a little more of the code, and maybe an example of the mysql database. (how its setup)
|
Posted by blueroomhosting, 08-08-2008, 01:08 PM |
Can you please post the full text of the error you are seeing?
|
Posted by Syphic, 08-08-2008, 11:22 PM |
I never solved it but i just did SHOW TABLES IN table LIKE 'site\_%'
thanks
|
Add to Favourites Print this Article
Also Read
HTTPme (Views: 569)