[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