We know. And already have http://code.google.c…detail?id=1648. Feel free to add yourself there if you find that it is not fully what you tell here.
Obviously Data Search will fire a lot of simple queries with a WHERE or REGEXP -clause of which many may not be well-optimized (as in lots of cases an index will not be used). As the first step we will add an option to search only specific tables of a database and/or specific columns of a table. One developer has started this today actually.
A few more specific replies:
* As long as we use the LIKE operator with %-wildcards all data are handled as strings. MySQL has no problem with this.
I think personally that searching a subset of tables in a database for isntance should be handed by Object Browser selection of those tables (and not more checkboxes or whatever). But next review meeting in SQLyog team should decide final implementation details.