Partial Search Query

[inveni0]

How do you query a mySQL database for entries partially matching your search?

For instance, if my database stored names, and one guy wa named Jonathan, and I search for Jon...Jonathan would show up as a result.

[coopster]

You can use the LIKE [dev.mysql.com] string comparison function:

SELECT firstname FROM mytable WHERE firstname LIKE 'Jon%';