MySql code to get prime numbeRs

Question

From a tabLe with a column of numbers from 1 to 100. Without using create or declare

Answer 1

it won't Work for square numbers and odd multiples