Question and answer is powered by AnsPress.io
using PHP Codeigniter framework I want to select rows from MySQL using LIKE. HOw to use LIKE in my selected query. Help me to select data from database using LIKE in Codeigniter.
If you want to select rows from MySQL Table using LIKE in Codeigniter use this.
<?php where("Column Name LIKE '%$Variable%'") ?>
For Example:
<?php $sec_qryc=$this->db->select('*')->from('Table Name')->where("username LIKE '%$user_search_name%'")->get()->result(); return $sec_qryc; ?>