Using Wildcard in MYSQL (1 Viewer)

[RajaGautam]

Hi! I want to select persons with a last name that starts with "b" or "s" or "p" from the "Persons" table. Here goes SELECT Statement,

SELECT * FROM Persons WHERE LastName LIKE '[bsp]%'

But MySQL returned an empty result set. How to fix it?

 

[plog]

Remove the brackets and use multiple criteria calls. You can't do it all at once.

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html