Do a *all field* search with defining all the fields...possible?

[Shrum]

I have a search engine that I wrote. The problem is that the database that it is working on will evolve from time to time and may add/delete fields as time goes by.

Short of writting a procedure to read the database field names out of the database, thus adding more processing time to a already time-intensive process already, I figured I try the simplest solution first...

Is it possible to define a SELECT statement where the WHERE clause is wildcarded? Sorta like:

SELECT * WHERE * LIKE 'mysearchtext'?

TIA

 

[vbkris]

wildly experimental:

SELECT * from Table_name a where a.* LIKE 'mysearchtext'






Known is handfull, Unknown is worldfull

 

[Shrum]

Bummer...just tried it and no go : error message.

Keep the ideas coming and I'll throw um at it.

TIA

 

[Shrum]

Found it....

MATCH clause

http://www.mysql.com/doc/en/Fulltext_Search.html

 

[Shrum]

Opps...premature...you still need to specify field names.

HEY!

The MATCH method does search scoring! That's KEWL!

 

[vbkris]

oops ran out of ideas...

Known is handfull, Unknown is worldfull