mysql - Using LIKE when searching for "%" -

this question has answer here:

• match '%' sign when searching in mysql database 5 answers

i want check whether column starts "%". if search character code below doesn't work when searching "%".

select * `table` `column` 'anothercharacter%' 

thanks.

you can try this

select * `table` column 'anothercharacter%[%]%' 

or

where column '%\%%' escape '\'