[RESOLVED] Need help building query.

[JamesBrauman]

Hello,
I would like to build this mySQL query to retrieve data in php but I don't know how..

I have a list of jokes varying in size. I would like to select a random one, but the character length of the joke selected cannot be more than 100 characters.

The field where the joke is contained is 'joke' and the table is called 'jokedata'.

Thankyou.

[NogDog]

SELECT joke FROM jokedata WHERE CHAR_LENGTH(joke) <= 100 ORDER BY RAND() LIMIT 1

[JamesBrauman]

NogDog;10884953 wrote:

SELECT joke FROM jokedata WHERE CHAR_LENGTH(joke) <= 100 ORDER BY RAND() LIMIT 1

Thankyou for the quick reply. 🙂