... SET @new_jos_categories_extension_alias=(
SELECT `alias`
FROM `my_new_database`.my_prefix_categories
WHERE `extension`='com_content'
ORDER BY `id` ASC
LIMIT 0,1);
...
... use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional for most SQL forms) ...
... title
alias => sort by alias title
url => sort by url
description => sort by description
date => sort by date added (most recent or oldest first)
hits => sort by hits ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.