i have a table id did name
now i want to make a quarry to find id 4 with name 00123and me
or i want to get id 2 searching name with 001bang1
What I have tried:
SELECT * FROM `subdomain` WHERE `did` = 18 AND `name` LIKE '%00123andme%'