## Is there a search engine that supports searching using regex or wildcards?

I have a part of email address. I need to find a full one.
Part of email address example: amazon***@gmail.com.
I want to find all emails on web where characters instead of *.
As far as I know, Google doesn’t support it. (Or no?)
So, is there a search engine that can help me?

## file management – Are wildcards available in setting up MiXplorer AutoTasks?

I want to set up an auto-task in MiXplorer to delete two types of files that another application creates — one appears in two different folders, and another is in one folder but has different numeric strings appended to it each time it’s created. Is it possible to set a task for each with a wildcard that will work on either, like /internalstorage/\$/.crap.tmp and-or internalstorage/backups/system/crap_\$ (where ‘\$’ is some wildcard character or string).

I tried asterisks, but that didn’t work, and tried figuring out if there was something to the regex renaming format that I could understand and use, but couldn’t.

I’m using android 8.0.0, MiXplorer 6.46.1.

Thanks much.

## wildcards in user black list

Hello,

is it possible to use wildcards in user’s blacklist?

why ?

I want to filter out some words in domains –  like all domains with “.ru”  or “.tk” or….   (many)

there is the option to remove urls containing  ..  but i have quite a long list of strings to filter out.  it takes a lot of time to manually do it.  is there a way to automate it?  maybe through users blacklist??

thank you

## interpolation – Interpolating Polynomial with Wildcards

I’d like a polynomial through a set of points and also with given critical $$x$$-values. I’ve been using `InterpolatingPolynomial` but it seems as if I need to specify the function value (which I don’t care about) for the critical points. Is there a way to use something like wildcards to avoid having to give this information?

Maybe an example would help explain what I’m trying to do: I want a polynomial through the points (-5,0), (-3,0), and (1,2). Also, the polynomial should have zero derivatives at $$x=-4$$ and $$x=-1$$. So I’d like to do something like: `InterpolatingPolynomail({{-5,0},{-3,0},{1,2},{-4,?,0},{-1,?,0}},x)` where the `?` is a placeholder for info that I don’t want to specify because I don’t care what value it is.

What I’ve been doing is:

• Putting parameters in those spots: `InterpolatingPolynomial({{-5, 0}, {-3, 0}, {1, 2}, {-4, a, 0}, {-1, b, 0}}, x)`.
• Using `CoefficientList` to find the coefficients of the two highest terms.
• Using `Reduce` to solve for the parameters that make these coefficients zero.
• Using these parameters gives the minimal degree polynomial satisfying the criteria.

But it sure would be nice to do that all in one call.

## MS-Word wildcards: How to find texts that match either of two strings

I wanna find `am` or `pm` in a MS-Word document. I’ve tried all these wildcard expressions, but none of them works:
(am|pm)
((am)|(pm))
(am)|(pm)

## replacement – Pattern matching involving a sum of wildcards

I am trying to implement the following substitution to an expression in Mathematica:

``````ti den(a-ti) -> -1 + a den(a-ti)
``````

where `ti` can be `t1`, `t2`, …, and `den` is an undefined function. The variable `ti` can also be a sum of `t1`, `t2`, …. The expression is part of a larger expression.

Now, it works when one variable is involved:

``````t1 den(s1 + s2 - t1) /. t_ den(q_ - t_) -> (-1 + q den(q - t))
``````

returns

``````-1 + (s1 + s2) den(s1 + s2 - t1)
``````

However, if `ti` is a sum of multiple terms, e.g. `(t1-t2)`, the replacement breaks down. I’ve tried to implement a rule with the combination of `ReplaceRepeated`.

``````rule = {t_ den(q_ - t_) :> (-1 + q den(q - t))}
(t1 - t2) den(s1 - s12 + s2 - t1 + t2) //. rule
``````

but that doesn’t seem to work, because it just returns

``````(t1 - t2) den(s1 - s12 + s2 - t1 + t2)
``````

My guess is that Mathematica cannot recognize `den(s1 - s12 + s2 - t1 + t2)` as `den(s1 - s12 + s2 - (t1 - t2))` and that my substitution rule is wrongly formulated.

Does anybody know how to fix this?

## php – MySQL 8 vs MySQL 5: Why wildcards misbehave in GRANTs command?

I came across with one of my old projects (using MySQL 5 and PHP 5.5). I’ve just wanted to test that project using MySQL 8 and PHP7.0.
To install the DB i normally do:

``````...
mysql -u root -p < DBinstall/webAppDBinstall.sql
...
``````

in a “install” script for my web app.
The sql commands contain:

``````...
-- # ######################## SET PHP_SCRIPT & GRANTS FOR ############################
CREATE USER 'php_script'@'localhost' IDENTIFIED BY 'php_script';
GRANT INSERT,SELECT ON webApp.* TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.Orders TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.OrderItems TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.UserStatus TO 'php_script'@'localhost';
GRANT INSERT ON webApp.History TO 'php_script'@'localhost';
...
``````

Then i get the following error from PHP when running the webApp:

`\$ cat /var/log/apache2/error.log`

``````...
(Thu May 28 06:01:26.317867 2020) (:error) (pid 8906) (client 127.0.0.1:32960) PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /var/www/webApp/src_php/mylib.php on line 68, referer: http://webApp/index.php?error=0
...
``````

Note: that this project was running flawlessly using MySQL 5 and PHP 5.

Then i thought that “it smells” like being a privilege matter. So i did the following:

``````mysql> select User,Table_name,Table_priv from mysql.tables_priv where User='php_script';
+------------+------------+------------+
| User       | Table_name | Table_priv |
+------------+------------+------------+
| php_script | History    | Insert     |
| php_script | OrderItems | Update     |
| php_script | Orders     | Update     |
| php_script | UserStatus | Update     |
+------------+------------+------------+
4 rows in set (0.00 sec)

mysql>
``````

## Yeap, that’s what it is.

Here is the proof:

I changed the my `DBinstall/webAppDBinstall.sql` script FROM:

``````...
-- # ######################## SET PHP_SCRIPT & GRANTS FOR ############################
CREATE USER 'php_script'@'localhost' IDENTIFIED BY 'php_script';
GRANT INSERT,SELECT ON webApp.* TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.Orders TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.OrderItems TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.UserStatus TO 'php_script'@'localhost';
GRANT INSERT ON webApp.History TO 'php_script'@'localhost';
...
``````

TO:

``````-- # ######################## SET PHP_SCRIPT & GRANTS FOR ############################
CREATE USER 'php_script'@'localhost' IDENTIFIED BY 'php_script';
GRANT INSERT,SELECT ON  webApp.Users TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.UserStatus TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.Categories TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.ProductGroups TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.CategoriesGroups TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.Products TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.Orders TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.OrderItems TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.Messages TO 'php_script'@'localhost';
GRANT INSERT,SELECT ON  webApp.History TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.Orders TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.OrderItems TO 'php_script'@'localhost';
GRANT UPDATE ON webApp.UserStatus TO 'php_script'@'localhost';
GRANT INSERT ON webApp.History TO 'php_script'@'localhost';
``````

And THE RESULT IS:

``````mysql> select User,Table_name,Table_priv from mysql.tables_priv where User='php_script';
+------------+------------------+----------------------+
| User       | Table_name       | Table_priv           |
+------------+------------------+----------------------+
| php_script | History          | Select,Insert        |
| php_script | Categories       | Select,Insert        |
| php_script | CategoriesGroups | Select,Insert        |
| php_script | Messages         | Select,Insert        |
| php_script | OrderItems       | Select,Insert,Update |
| php_script | Orders           | Select,Insert,Update |
| php_script | ProductGroups    | Select,Insert        |
| php_script | Products         | Select,Insert        |
| php_script | UserStatus       | Select,Insert,Update |
| php_script | Users            | Select,Insert        |
+------------+------------------+----------------------+
10 rows in set (0.00 sec)

mysql>
``````

### Any other better thoughts about ‘why this happens with wildcards in `GRANT`s’ ???

(SORRY for duplicating my question BUT stackoverflow has BANNED me for answering my own questions)

My question is: Why the `GRANT <PRIVS> ON <DB>.* TO <USER>;` wildcards syntax stopped “working”

## Word – Find and replace wildcards / expressions

Trying to find the fastest way to set a style for specific lines of text in Word.

I have a document with CHAPTER 1, CHAPTER 2, etc. at the top of a page. The lines with CHAPTER x are all set as style "Heading 1". After the line CHAPTER x follows a return and then a line of text which is currently defined as "Normal". I need this special line for each chapter labeled "Heading 2" followed by 2 blank lines (the text in the next lines will remain "Normal").

To illustrate:

``````CHAPTER 15  (already set as H1)
Subhead here (which is currently Normal and needs to be H2)
Paragraphs of body text follow which are set as Normal style
Then there is a page break and the next Chapter with another subhead to set and do the same thing to end of doc

CHAPTER 16
``````

Hope that makes sense. Not sure if there is a way to find and replace each chapter to set multiple styles using wildcards or phrases?

Thanks a lot!

## PHPLIST – Pass variables through wildcards to link to the PHP file

Hi

I'm using phplist and need to send a newsletter asking you to click yes or no. I need to forward the e-mail to register in db, but to forward the e-mail, it must be via a URL or a form. Phplist always encrypts the URL or code with a click of the button to count statistics …

Therefore, I can not pass the email variable to the PHP file where I have the code for the DB.

Can someone help me?
Thank you very much

## Algorithm for finding strings with wildcards

I am trying to find an efficient algorithm to check if a string of wildcards contains a particular substring.

The parts of the string are marked with a "." Character.

So, for example, I have

`ab.cd.*.efg`

And I want to search for given strings if they are substrings listed above, for example, to match them:

``````ab
b.c
cd.qq <- "qq" is replacement for wildcard
d.qwe.ef <- "qwe" is replacement for wildcard
``````

What is the best algorithm?