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.

[Back to original message]