Re: select problems

[Felix Geerinckx]

Alexander Bradley wrote:

> If i use the following select statement, no records are returned.
>
> select * from countries where continent='europe'
>
> However, if i use;
>
> select * from countries where continent like 'europe%'
>
> then the appropriate records are returned.

What do you see when you

SELECT CONCAT('*', SUBSTRING(continent, -1, 1), '*') as LAST_CHAR FROM countries;

--
felix
Please use BBCode to format your messages in this forum.