[thelist] daft mySQL query (v 3.23.39)

john at johnallsopp.co.uk john at johnallsopp.co.uk
Wed Jul 28 06:43:32 CDT 2004


Have I gone daft?

I've a table with a single field in it: STOPWORDLIST_word

SELECT * FROM `STOPWORDLIST` WHERE STOPWORDLIST_word = 'the'; returns no
result line (in PHPadmin) (and mysql_num_rows($result) returns 0), whereas

SELECT * FROM `STOPWORDLIST` WHERE STOPWORDLIST_word <= 'the'; returns all
the words including the.

There's not a rule that says "if there's only one data element in the
result, don't show it", surely.

Or am I using the wrong coloured = today?

J


More information about the thelist mailing list