Why am I getting the warning: truncated incorrect DOUBLE value: '%asian%'

See more:

MySQL

I am trying to run this query:

SELECT r.restaurant_name FROM restaurant as r, ethnicity as e, allergen as a WHERE e.restaurant_id=a.restaurant_id AND e.restaurant_id=r.restaurant_id AND a.restaurant_id=r.restaurant_id LIKE a.allergen='%fish%' LIKE e.ethnicity='%asian%';

If it helps this is the schema of all the tables in this query:

DESCRIBE ethnicity;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| restaurant_id | int(11) | NO | MUL | NULL | |
| ethnicity | varchar(255) | NO | | NULL | |
+---------------+--------------+------+-----+---------+-------+

DESCRIBE restaurant;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| restaurant_id | int(11) | NO | PRI | NULL | auto_increment |
| restaurant_name | varchar(255) | YES | | NULL | |
| phone_number | varchar(255) | YES | | NULL | |
| address_1 | varchar(255) | YES | | NULL | |
| address_2 | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| state | varchar(2) | YES | | NULL | |
| zip | int(11) | YES | | NULL | |
| filename | varchar(255) | YES | | NULL | |
| image | longblob | YES | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+

DESCRIBE allergen;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| allergen | varchar(255) | YES | | NULL | |
| restaurant_id | int(11) | YES | MUL | NULL | |
| menu_item_id | int(11) | YES | MUL | NULL | |
| allergen_id | int(11) | NO | PRI | NULL | auto_increment |
+---------------+--------------+------+-----+---------+----------------+

What I have tried:

I have tried running separate queries (broke the query into smaller parts) to find which part of this query is not working but every part works fine.

I looked up the error I am getting and what I found was this is usually given when unnecessary AND's are used or apostrophes are missing, only problem is that's not the case for my query.

Would appreciate the help of a seasoned or knowledgable person in MYSQL :)