查询以查找包含字母的字段中的所有单词

I am trying to run a query that can find all the records from a field contains the letters. For example suppose a state field contains a record value "New York" and another record conatains NY. Now i am searching for NY or New york will return these 2 records. What will be the query. Currently i am usingI am trying to run a query that can find all th