[Dean C]

Hi,

Thanks to my good friend Stefan (Xenon) he has kindly taken some of his free time to write me a script for a maths project for college.

I've already taken too much of his time so i feel guilty in asking him to make on final modification.

Basically i have this query:

[sql]
SELECT title FROM word ORDER BY RAND() LIMIT 100
[/sql]

It selects 100 random words from the word table. Now the problem with the word table is that it picks up mistakes and adds them. For example things like this would appear in the table:

one...day

________

Now i want it to just ignore these and also to ignore words with apostrophes and dashes etc. So basically i only want it to select words that consist of the 26 letters in the alphabet and no extra characters. Can someone modify that query above to do that for me

Thanks in Advance

- miSt