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...
views:
25answers:
2
+1
A:
Yes, it's called Full Text Search.
You can use MySQL's built-in Full Text Search, or use a separate product to do you text indexing such as Apache's Lucene (my personal favorite).
Pablo Santa Cruz
2010-09-26 13:13:37
umm - hi Pablo - how do I use it? It sounds like I need to modify my columns?
matt_tm
2010-09-26 13:42:58
Full Text doesn't help, you still have to enumerate all the fields you search in.
Wikeno
2010-09-26 13:48:44
@matt_tm, you don't need to modify your columns, you just need to create a FULL TEXT index on all the columns you want to search. It's like creating an index.
Pablo Santa Cruz
2010-09-26 14:57:03
@Wikeno: true. But I think he's trying to avoid a **HUGE** where clause here, concatenated by **OR** conditions... I might be wrong though...
Pablo Santa Cruz
2010-09-26 14:59:15
A:
It is not possible with one query.
However when you do:
DESCRIBE table_name;
you get the field names which you can generate the query from.
http://stackoverflow.com/questions/639531/mysql-search-in-all-fields-from-every-table-from-a-database May be useful.
Wikeno
2010-09-26 13:59:17