[thelist] daft mySQL query (v 3.23.39)
Sarah Sweeney
mr.sanders at designshift.com
Wed Jul 28 07:51:34 CDT 2004
> 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.
Is it possible the record with the word "the" has some extra spaces in
it? Have you tried this to see what it returns?
SELECT * FROM `STOPWORDLIST` WHERE STOPWORDLIST_word LIKE 'the%';
--
Sarah Sweeney
Web Developer & Programmer
Portfolio :: http://sarah.designshift.com
Blog, etc :: http://hardedge.ca
More information about the thelist
mailing list