robinwemen@email.com Posted September 23, 2007 Share Posted September 23, 2007 The Salary database's table structure is as below; Salary A B C D E a1 b1 c1 a2 b2 . a3 . . . . . . . an what if i need to search one specific string in all data fields in just only one query, This is what i like to do; SELECT * FROM A, B, C, D, E WHERE * LIKE 'aus%' .... something like that!! What exactly the query it should be? any one knows??? I'm using MYSQL 5 Quote Link to comment https://forums.phpfreaks.com/topic/70333-search-all-tables-within-one-database-in-one-query/ Share on other sites More sharing options...
fenway Posted September 24, 2007 Share Posted September 24, 2007 Either use a full text index to cover all 5 columns, or use a lot of LIKE clauses. Quote Link to comment https://forums.phpfreaks.com/topic/70333-search-all-tables-within-one-database-in-one-query/#findComment-354117 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.