Posted by Sjoerd on 04/14/06 12:11

kristian wrote:
> mysql
> supports the * like this 'apple*'

I think you want this:

SELECT * FROM table WHERE textfield LIKE '%apple'

This selects everything where textfield ends on apple. See chapter
12.3.1 in the MySQL 5.0 reference manual.

• Next in forum: sql counting duplicates
• Prev in forum: Re: Problem with session variable
• Thread view: Re: mysql fulltext

[Reply to this message]