Sum a specific range of numbers in a column using MYSQL

Question

I have a slider that calculates the BPM of a song. Range is 15 to 300 bpm. It connects to MySql database using php language and when I press edit button I can change its value. For example from 50 to 55bpm. table=users|columns=song_one.

\

What I want is if I change the value below 15 and above 300, not accept it. How can I do this? I've heard something about constraints..

I tried it, but it didn't work.

ALTER TABLE users
ADD CONSTRAINT song_one CHECK (num >= 15 AND num <= 300);

Any information would be very helpful, thank you

Answer 1

This will work for you.

ALTER TABLE users
    MODIFY COLUMN song_one INT CHECK (song_one >= 15 AND song_one <= 300);