I need to write a Query that grabs a number from a specific table but I'm not sure how to write it.
The table entry that I need to look at has the following;
entry_id, title, url_title
there are entries in this table ;
entry_id = 353
title = 230
url_title = order_230
entry_id = 354
title = 231
url_title = order_231
entry_id = 355
title = 232
url_title = order_232
I need to write a query that grabs the title value and add 1 to it title +1 where the url_title has the highest value.
So from the data above I would need to write something like;
$Q = SELECT title
WHERE url_title Contains order_% That is the highest value.
The query needs to contain the order_ part cause not every entry in that field is formatted the same way. There are other title formats.
Does this make sense?