CODE EXAMPLE FOR JAVASCRIPT

like knex

knex('users').where('columnName', 'like', '%rowlikeme%')
Outputs:
select * from `users` where `columnName` like '%rowlikeme%'