I've got a text field called source_recid. It stores half string half
number like strings in it.
the syntax is DATABASENAME.TABLENAME.RECID
My goal is to scan this col and find out the biggest RECID ( the
integer) in it.
So, in a case like this
It would be the record whose source_recid is shop.orders.82000. Why? Cause
82000 happens to be the largest integer.
What SQL statement would get me that record?
One option to this is to create a new column ( the_ids ) and move all the
integers in it and then run something like this
select source_recid from mytable where source_recid like 'shop.orders.%'
order by the_ids DESC LIMIT 1
Is there a way to pull this off without going thru this step?