Welcome Guest, Not a member yet? Register   Sign In
SQL Query - full text - order by score.
#1

[eluser]Unknown[/eluser]
I am moving my plain old php site to CI. How can I replicate this SQL within a CI query?

Code:
$sql = "SELECT *, MATCH(title,caption,locName,name,text,keywords) AGAINST ('%" . $q . "%' IN BOOLEAN MODE) AS score
  FROM `dartmoorArchive`.`mainArchive`
  WHERE MATCH(title,caption,locName,name,text,keywords) AGAINST ('%" . $q . "%' IN BOOLEAN MODE)
  ORDER BY score DESC


Messages In This Thread
SQL Query - full text - order by score. - by El Forum - 07-19-2012, 06:57 AM
SQL Query - full text - order by score. - by El Forum - 07-19-2012, 07:37 AM
SQL Query - full text - order by score. - by El Forum - 07-19-2012, 07:39 AM
SQL Query - full text - order by score. - by El Forum - 07-19-2012, 08:02 AM
SQL Query - full text - order by score. - by El Forum - 07-21-2012, 07:27 AM



Theme © iAndrew 2016 - Forum software by © MyBB