SQL How can I do query to find only decimal prices from the table?

Question

My query for now is:
select id, name, price
from product
where name like '%a%' and price '%,%'

But this '%,%' looks weird :)
Is there any other better way?

Answer 1

Is this way worked?

Answer 2

It is working but I need to know if there is some other way to find from all prices only decimal numbers (only prices with amount after ',' like for example from table with prices: 200; 3,06; 58; 243,79; 10; in output should be: 3,06; 243,79).