Use this query
SELECT * FROM username_table WHERE username like 'john%''john?[0-9]c/o'
Use this query
SELECT * FROM username_table WHERE username like 'john%'
Use this query
SELECT * FROM username_table WHERE username like 'john?[0-9]c/o'
default