1 Vote Vote

MYSQL query for searching through ALL the fields?

Posted by topdog 605 days ago Questions| fields mysql searching All

As dumb as it sounds, is there a way to do something like this:

select row_id from mytable where * like '%searched_text%';

By * here I mean "all the fields" in the table, instead of me specifying them one by one...

Originally asked by: matt_tm on Stack Overflow

Discuss Bury


Who Voted for this Question