homepage Welcome to WebmasterWorld Guest from 54.167.10.244
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Information Schema
ZakAltF4




msg:4418954
 8:51 pm on Feb 17, 2012 (gmt 0)

I am using SSH on a linux box to run queries for quick access to info etc... I seem to have misplaced my brain, however and can't for the life of me figure out the syntax for searching ALL databases and ALL tables for a '%like%' ... This is what I have so far, any input/help greatly appreciated!

->SELECT * from INFORMATION_SCHEMA WHERE * LIKE '%like%';
-> No database selected ...

How do I search where database = * ?

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved