SELECT * FROM tableName WHERE colName = 'test
other chars \ '' " _ % àèìòù'

//Sudo for Understanding
SELECT * FROM tableName WHERE colName like concat('%test%', '%other%', '%chars%')

SELECT * FROM tableName WHERE colName like 'test%'