Welcome Guest, Not a member yet? Register   Sign In
How use MATCH(action) AGAINST(?)
#1

How use MATCH(action) AGAINST(?) in Query Builder Class
i have found only like mode
Reply
#2

I found this one, give it a try.

Using Match and Against in MySQL and CodeIgniter
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#3

(This post was last modified: 04-28-2025, 10:42 PM by WitER.)

(04-28-2025, 02:46 PM)motoroller Wrote: How use MATCH(action) AGAINST(?) in Query Builder Class
i have found only like mode

You can try to use RawSql:
PHP Code:
->where(new RawSql("MATCH(action) AGAINST ('words for search')")); 
Reply
#4

(04-28-2025, 10:39 PM)WitER Wrote:
(04-28-2025, 02:46 PM)motoroller Wrote: How use MATCH(action) AGAINST(?) in Query Builder Class
i have found only like mode

You can try to use RawSql:
PHP Code:
->where(new RawSql("MATCH(action) AGAINST ('words for search')")); 

Got it how use variable? and prevent sql Inhections?

PHP Code:
->where(new RawSql("MATCH(action) AGAINST ($variable)")); 
Reply
#5

(04-30-2025, 06:54 AM)motoroller Wrote:
(04-28-2025, 10:39 PM)WitER Wrote:
(04-28-2025, 02:46 PM)motoroller Wrote: How use MATCH(action) AGAINST(?) in Query Builder Class
i have found only like mode

You can try to use RawSql:
PHP Code:
->where(new RawSql("MATCH(action) AGAINST ('words for search')")); 

Got it how use variable? and prevent sql Inhections?

PHP Code:
->where(new RawSql("MATCH(action) AGAINST ($variable)")); 

In a doc
Reply




Theme © iAndrew 2016 - Forum software by © MyBB