The city of New Orleans is home to the New Orleans Hornets, formerly of Charlotte, North Carolina. The team has been located there since 2002, though it relocated to Oklahoma City for two years following Hurricane Katrina.
The answer to this question, in the New Orleans Hornets. The New Orleans Hornets are previously from, Charlotte, North Carolina. The Hornets moved from Charlotte, to New Orleans, in 2002. They have been in the NBA, since 1988.
Assuming you mean NBA, the name of the basketball team in New Orleans is the Hornets. They used to be the Charlotte Hornets, but they moved to New Orleans a few years ago.