Sql get results only containing all keywords
I have found the answer and I will write it here as it may be useful for someone.

First I have altered tables by marking it up on Mysql database and clicking "Fulltext". 

To use multiple keywords, use this code (which will get ) before mysql query (in php):

$search="ACDC 2000"; // any keyword 
$search=explode(' ', $search );
$Asearch = array();
foreach($search as $result) {
    $Asearch[] .= '+'.$result.'*';
}


Then use this mysql query:

SELECT * FROM songs WHERE MATCH(artist,featuredartist,year) AGAINST('".join(' ',$Asearch)."' IN BOOLEAN MODE)


You will get only results which include all entered keywords.