use the same way, u can write sql like this: select * from customer where ucase(customername) like '%strtoupper($cname)%'; or: select * from customer where lower(customername) like '%strtolower($cname)%'; select * from customer where lcase(customername) like '%strtolower($cname)%';
select * from customer where ucase(customername) like '%strtoupper($cname)%';
or:
select * from customer where lower(customername) like '%strtolower($cname)%';
select * from customer where lcase(customername) like '%strtolower($cname)%';
select * from customer where customername like '$cname%'