+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: search query (/showthread.php?tid=52119)
search query - El Forum - 05-30-2012
[eluser]r0mel[/eluser]
hi everyone, just one to ask if you some idea about text search using query in php sample:
->query
Code:
$this->db->query("select * from SEARCH where title like '%hows%'");problem: the query above doesn't produce anything because what is in the table is how,,
do you any idea about that?
SEARCH TABLE
id title
1 how
2 know
search query - El Forum - 05-30-2012
[eluser]Otemu[/eluser]
The syntax looks correct however try this
Code:
$this->db->query("SELECT * FROM SEARCH where title LIKE '%how%'");Also check the query within MySQL/phpMyAdmin and see if it returns any results