Welcome to WebmasterWorld Guest from 54.196.5.163

Forum Moderators: open

Message Too Old, No Replies

Information Schema

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

New User

5+ Year Member

joined:Jan 12, 2012
posts: 38
votes: 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 = * ?
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members