How to retrieve all data from table if column value providing null value?
This should do the job.

DECLARE @country1 varchar(30)
SET @country1 = 'asd'

SELECT country_id, country
FROM   country
WHERE country.country LIKE IF(@country = '', '%', @country); 


The IF statement works like this : IF(condition, ifverifiedcondition, else);