[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