MYSQL query for searching through ALL the fields? -

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

  Mytable Choose row_id from where * like '% search_text%';  

From here I mean that "all fields" in the table, specify them instead of one ...

This is not possible with a query.

While you do:

  DESCRIBE table_name;  

You receive the field name, from which you can generate a query.

May be useful.