On Thu, 2005-08-18 at 16:25, Mark Unwin wrote:
> Is there a shortcut way (rather than manually doing a SQL Statement for
> each column), to search ALL columns in a table ?
> I have people wishing to search for text in different fields - and I'd
> like to know if there is a way to query for all columns on a given table
> in one SQL statement. (yes, I'm being lazy - or is that efficient
> ?!?!?!). Or maybe a selection of columns. Or even all columns in all
> tables (don't ask).
A FULLTEXT index can cover multiple columns.
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL related blogs @ http://www.planetmysql.org/