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' 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 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
Archived
This topic is now archived and is closed to further replies.