pioneerx01 Posted February 25, 2012 Share Posted February 25, 2012 Ok so standard query can be written as: SELECT * FROM my_table WHERE specific_field = 'some_term' Is there some query that I can search for 'some_term' in all the fields at once in my_table without defining them in the query? SELECT * FROM my_table WHERE any_field = 'some_term' Quote Link to comment https://forums.phpfreaks.com/topic/257739-query-any-fileds-in-the-table/ Share on other sites More sharing options...
joel24 Posted February 25, 2012 Share Posted February 25, 2012 Not without fetching the schema, looping through the fields and adding it to your query... you could write a function to do this http://stackoverflow.com/questions/3797906/mysql-query-for-searching-through-all-the-fields Quote Link to comment https://forums.phpfreaks.com/topic/257739-query-any-fileds-in-the-table/#findComment-1321018 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.