mySQL query to filter a field is not like given pattern -

i have mysql query select fields table username in table doesn't start "abc\". tried create query not working.

select * user username not 'abc\%' 

but not working. new queries , can manage write simple queries 1 not sure if following correct way.

you need escape slash (\). in mysql slash (\) used escape characters in query.

select * user username not 'abc\\\\%'