Limit selection to match criteria

limit selection TO MATCH criteria:
note that while SQL IS NOT CASE senstive, DATA IS :
SELECT   *    FROM bikes   WHERE   NAME = "Beene"