Making search "contains" or alike sql "like %term%

Users
1

hi,

how do i do search for specific keywords that may match part of a text?
example: “admin” matches “admin” and “superadmin” and “super admin” and “adminblabla” and “blablaadmin”

2

I think regexp can work for you.