How to search for a name in two columns in MySQL?
I suspect that Hamed is the first name and Haddadi is the last name, you can do it in 3 ways;

Solution 1:

Split the query in name and last name:

SELECT * 
FROM nbaplayermaster 
WHERE firstname LIKE "%Hamed%" OR 
      lastname LIKE "%Hamed%";


Solution 2:

Use the wildcard % in between the names(spaces)

SELECT * 
FROM nbaplayermaster 
WHERE firstname LIKE "%Hamed%Haddadi%" OR 
      lastname LIKE "%Hamed%Haddadi%";


Solution 3:(recommended)

Add a fulltext index on this 2 columns:

ALTER TABLE nbaplayermaster ADD FULLTEXT KEY `full_name` (`firstname`,`lastname`);


and then search using the fulltext index

SELECT * FROM nbaplayermaster WHERE MATCH(firstname,lastname) AGAINST ('Hamed Haddadi');