How to get the last inserted value in a column

Question

Is there any function I can use to get the last inserted value in my column thread_id?

$result =  DB::insert("Insert Into $this->table (thread_id, sender_id, subject, message, date_sent)
                Select COALESCE(max(thread_id),0)+1 , ? , concat('Re: ',subject), ? , now() FROM $this->table Limit 1",array( $sender_id  ,  $message) );

something like insertGetId

http://stackoverflow.com/questions/17139935/laravel-4-return-the-id-of-the-current-insert — CMPS, Apr 08 '14 at 04:17
http://stackoverflow.com/questions/21084833/laravel-get-last-insert-id-using-eloquent — CMPS, Apr 08 '14 at 04:18
@JosephSilber I suggested some answers because similar question were asked before — CMPS, Apr 08 '14 at 04:20
@AmirBawab - To repeat: none of those answer the question. The OP is aware of `insertGetId`, but wants a different column. — Joseph Silber, Apr 08 '14 at 04:21

score 1 · Accepted Answer · answered Apr 08 '14 at 04:17

1

You'll have to perform another query yourself:

$id = DB::table($this->table)->insertGetId('...');

$thread_id = DB::table($this->table)->where('id', $id)->pluck('thread_id');

answered Apr 08 '14 at 04:17

Joseph Silber

214,931
59
362
292

How to get the last inserted value in a column

1 Answers1