[Solved] Need Help In Sql like query

by


If I understood you need something like that:

SELECT * 
FROM YourTable
WHERE meta_value LIKE '% carter %'

This will work for you, because added wildcard % before and after word carter. This means, that no care what is before and after carter, It will select all results where is middle name carter

More info about LIKE and WILDCARDS can be found here

1

solved Need Help In Sql like query