Simple MySql questions

[mdowling]

Will this change all of the definitions entries with on command, or do I need to do them one at a time?

UPDATE definitions SET word = 'toot' where word = 'fart'

Will this select an entry from the table at random if the structure doesn't have an index (but using the supplied stipulations)?

SELECT * FROM `words` where definitions < 5

if not, how can I select an entry at random with < 5 definitions?

[shamly]

This is for your second query ..... change u r SQL query to the one i have given below ...

SELECT * FROM words where definitions < 5 ORDER BY RAND() LIMIT 1;

This should return a single random entry. But pls not that the same entry may return on successive executions sometimes .... 🙂

[leatherback]

As for the first question..
The easiest way is to test. Will aslo give your learning experience i think../

But yeah, it should work with one statement. The same for:

delete from TABLE where CONDITION