The SET field type vs. a lookup table

to be scalable. The FIND_IN_SET() function is mentioned on the page about the SET field type, but doesn't seem to have a proper manual entry itself. -- Tim Fountain | Web developer | Incutio Limited | www.incutio.com email: [EMAIL PROTECTED] | Tel: +44 8708 700 333 | Fax: +44 7092 181 581

Stopping MySQL taking down a server?

long these things take but the box shouldn't become unresponsive while they are running. -- Tim Fountain http://www.tfountain.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query optimisation question - two queries, one slow, one fast

be optimising these in the same way? Can anyone shed any light on this (short of "just use the second query" ;)), so I know what to do (and not to do) in the future. -- Tim Fountain | Web developer | Incutio Limited | www.incutio.com email: [EMAIL PROTECTED] | Tel: +44 8708 700 333 | Fax: +44 7092 181 581 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

TO_DAYS() equivalent for months, hours etc.?

,YEAR(time)) to achieve this result, or is there a better way? Cheers, Tim. -- Tim Fountain ([EMAIL PROTECTED]) http://www.tfountain.co.uk/ - Before posting, please check: http://www.mysql.com/manual.php (the manua

Fulltext searching - getting list of stop words?

list of current stop words from MySQL? Alternatively, how would I find out the default (assuming there is one) set of stop words used? Cheers, Tim. -- Tim Fountain ([EMAIL PROTECTED]) http://www.tfountain.co.uk/ - Before