CodeIgniter Forums - Search Results

Search Results

Thread: Databases: searching for a word in entries containing multiple words using 'like'
Post: RE: Databases: searching for a word in entries con...

Okay, so, as my actual code involves a complicated JOIN and I couldn't get the SQL query to work, what I've ended up doing is the following: Code: -- $this->db->where('title LIKE ', $search.'%'); ...

Thread: Databases: searching for a word in entries containing multiple words using 'like'
Post: RE: Databases: searching for a word in entries con...

paulkd Wrote: (05-14-2021, 02:40 AM) -- Hi, raw SQL for you to evaluate.. :) Code: -- SELECT * FROM test WHERE LOWER(words) LIKE '% art%' OR LOWER(words) LIKE 'art%' -- -- That looks li...

Thread: Databases: searching for a word in entries containing multiple words using 'like'
Post: RE: Databases: searching for a word in entries con...

wdeda Wrote: (05-13-2021, 05:13 PM) -- In the example below I have a 'names' table and I want to find all names that contain' Taylor': PHP Code: -- $sql = ("SELECT * FROM `names` WHERE` name` L...

Thread: Databases: searching for a word in entries containing multiple words using 'like'
Post: RE: Databases: searching for a word in entries con...

includebeer Wrote: (05-13-2021, 04:02 PM) -- I think you won't have a choice to use regex. I found this website a long time ago and it saved my life more than once, because I too I find regex complic...

Thread: Databases: searching for a word in entries containing multiple words using 'like'
Post: Databases: searching for a word in entries contain...

I'm trying to set up a search using like to find words in a table column 'title'. At first, I was using the following... Code: -- $this->db->like('title',$search); -- It worked fine, but I...