SQL 'WHERE' retrieve all data from a filter

With this query:

SELECT * 
FROM table1 
WHERE name = 'Peter'

I can retrieve all data from Peter from table1. This can be done with the "Wildcard *".

Question

Is there any kind of wildcard for the WHERE part? For example:

SELECT * 
FROM table1 
WHERE name = *

This option of course not working, but I am looking for a wild card there so that all names will be included in my query. I know it's easier to remove the WHERE statement, but due to some reasons I still need it.