How to match one character in MySQL in place of %?

You want to use an underscore (_) character. See the documentation here.

_ will match exactly one character :

select * from X where Y like "_s"