sql - select date_add mysql issue -

i have table loans in database schema this

loans ----- period (vchar) ' contains number string date amt user 

i needed select records loans the date + period equal or greater current date. when execute query below

select *  loans date( date_add( date, interval period day ) ) >= current_date limit 0 , 30 

i records in loans table. problem?

is you're looking for?

select columnlist loans curdate() < date_add(`date`, interval pay_period day)