like command

[gurechan]

Hi, I'm trying to set up a search form and using the LIKE command in MySQL, ie:

SELECT * FROM books WHERE title LIKE '%$search%'

Now say I have a heap of books that have the work [b]book [/b]in the title, this query works fine if you enter book in the search field, but if you enter [b]books [/b]you get no results.

Is there an easy way to get it to still find a match.

[AndyB]

http://mysql.com/doc/refman/5.0/en/pattern-matching.html

SELECT * FROM books WHERE title LIKE '$search%'

[gurechan]

Yeah, I've seen and tried that. Still has the same result tho.

[fenway]

Nope -- there's no easy way; you can hack and remove the trailing "s" and try the query again, but it's kludgy at best.