converting to abbreviations?

[__greg]

I recently developed a script where users can search through a database by state.

in my database, i have the state stored as the abbreviation ('NY' for New York, or 'CA' for California.

I was wondering if there is any way when a user types 'new york', to have it convert their query to 'NY' so it can display the results?

[lazzerous]

why not have an additional field in the database for that?

create table states (
  id int(2) unique auto_increment, 
  state_name char(20), 
  state_abbr char(2)
);

-=Lazzerous=-