i wanna fetch data from thd database on search query

Question

my query is

"select * from wb_customer where ( sFullName like '%test\'s%') order by sFullName asc"

the records such as test's are store in database but still it return empty row your suggestion for this

Answer 1

you should use:

"select * from wb_customer where ( sFullName like '%test''s%') order by sFullName asc"

Answer 2

try this:

 "select * from wb_customer where ( sFullName like \'%test\'s%\') order by sFullName asc"