[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