"SELECT TOP 1" equality for codeigniter?

Question

I need to get only 1 record from sql result. we use "SELECT TOP 1" in standard sql, but how can we do this in CodeIgniter? Is there any function for this? I explored the network so much, but could not find: /

appreciates! thanks,

Answer 1

with LIMIT

$this->db->limit(1); $query = $this->db->get('my_table'); $myRow = $query->row(); 

with OFFSET and LIMIT

 $query = $this->db->get('mytable', 0, 1); $myRow = $query->row(); 

Answer 2

Using

 $this->db->limit(1); 

Answer 3

Not sure about the encoder, but you can make regular choices and ordering and just use the first record to be returned, i.e. ignore those that come after that.

Basically, this is what the SQL engine does for you when you specify TOP 1 .

Answer 4

 SELECT * FROM table LIMIT 1 

is the syntax for mySQL