Answer the question
In order to leave comments, you need to log in
What does PLAN(NATURAL) output mean?
There is a base with a specific name SORT_ARCHIV_GAZ, it has a DATE field, in which CHAR is specified by type. The date is in the format dd:mm:yyyy. There is a task - to remove the fields with the year 2014. When I try to destroy them with the
delete from sort_archiv_gaz where sort_archiv_gaz.date < '01/01/2015' command,
I get the following output:
Plan
PLAN (SORT_ARCHIV_GAZ NATURAL)
Adapted Plan
PLAN (SORT_ARCHIV_GAZ NATURAL)
Well, nothing on the exhaust. What that conclusion is, I don't know. I work in IBExpert, Firebird 2.0, built-in SQL Editor.
If you try to delete one line by changing the command to:
delete from sort_archiv_gaz where sort_archiv_gaz.date = '07/01/2014
The output is the same.
Answer the question
In order to leave comments, you need to log in
Regulators are not needed here.
$urls = [
'https://steamcommunity.com/tradeoffer/new/?foo=bar&token=35b902385b90238509b23b52',
'https://steamcommunity.com/tradeoffer/new/?foo=bar&pew=1&token=v8d90awv5a985va85aw',
];
function extract_token($url)
{
parse_str(parse_url($url, PHP_URL_QUERY), $queryString);
return isset($queryString['token']) ? $queryString['token'] : null;
}
var_dump(extract_token($urls[0]));
var_dump(extract_token($urls[1]));
string(24) "35b902385b90238509b23b52"
string(19) "v8d90awv5a985va85aw"
$matches = array();
preg_match('/token=(.*)$/', "https://steamcommunity.com/tradeoffer/new/?partner... символы&token=любые символы", $matches);
echo $matches[1];//любые символы
preg_replace("&token=.*$", "", "http://abc/cde/?abc=def&token=tghjkldfghjklfghjk,");
It's not entirely clear what you need to do, if you just remove characters, it will be something like this:
preg_replace(''~=.+(&|$)~, '=$1', $url);
those.
all characters that come after "=" and end with "&" or "end of line"
should be replaced with
"=" + "&" or "end of line"
delete from sort_archiv_gaz where right(sort_archiv_gaz.date,4) < '2015'
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question