[thelist] daft mySQL query (v 3.23.39)

john at johnallsopp.co.uk john at johnallsopp.co.uk
Wed Jul 28 08:20:45 CDT 2004


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

> What is the structure of this table/field? Is it a varchar, char, text,
> etc?

It's a VARCHAR(20).

I just had the bright idea that, if >= works, why not try SELECT * FROM
`STOPWORDLIST` WHERE STOPWORDLIST_word <= "the" and STOPWORDLIST_word >=
"the"; but that returns nothing too :-(

J


More information about the thelist mailing list