[thelist] daft mySQL query (v 3.23.39)

[Tim Beadle]

On Wed, 2004-07-28 at 14:20, john at johnallsopp.co.uk wrote:
> 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 :-(

How about:

SELECT
  STOPWORDLIST_word, char_length(STOPWORDLIST_word)
FROM
  `STOPWORDLIST`
WHERE
  lower(STOPWORDLIST_word) LIKE 'the%'

??

That would show if there are any trailing spaces...

Not sure if char_length is right in MySQL - I'm more of a PostgreSQL
kind of guy :D

Tim
-- 
Tim Beadle <tim.beadle at iop.org>