Whats the MySQL equivalent of this SQLite code?

Question

"SELECT DISTINCT `Name` FROM ( SELECT * FROM `Aliases` WHERE ( `IP` GLOB 'ENTERED_NAME' ) ORDER BY `Datetime` DESC )"

Basically trying to get all the names that link to the same IP address as the "ENTERED_NAME".

Is there a MySQL equivalent to "GLOB" ?

`'IP' = 'ENTERED_NAME'`? Where `IP` is equal to `ENTERED_NAME`? That would do it. — Madbreaks, Jan 04 '13 at 23:35
The `LIKE` and `GLOB` operators in SQLite are described here: http://www.sqlite.org/lang_expr.html — Robert Harvey, Jan 04 '13 at 23:52

Bohemian · Answer 1 · 2018-10-06T10:28:45.040

2

GLOB uses wildcards, eg GLOB 'Foo*' to match anything starting with Foo. Mysql doesn't support this, but you can convert your string to work with LIKE as follows:

WHERE IP LIKE BINARY REPLACE('ENTERED_NAME', '*', '%') -- replace * with %

edited Oct 06 '18 at 10:28

answered Jan 05 '13 at 01:46

Bohemian

412,405
93
575
722

Actually, isn't the difference between `GLOB` and `LIKE` that `GLOB` is case-sensitive ? – Luatic Oct 06 '18 at 10:25
1

@LMD quite so - I’ve edited the answer to perform a [case sensitive like](https://stackoverflow.com/a/14007477/256196). – Bohemian Oct 06 '18 at 10:30

score 1 · Answer 2 · answered Jan 04 '13 at 23:44

SELECT DISTINCT `Name` FROM (
    SELECT * FROM `Aliases` WHERE ( `IP` LIKE '%[entered_name]%' ) ORDER BY `Datetime` DESC
)

...or...

SELECT DISTINCT `Name` FROM (
    SELECT * FROM `Aliases` WHERE ( `IP` = '[entered_name]' ) ORDER BY `Datetime` DESC
)

...where [entered_name] changes accordingly.

Whats the MySQL equivalent of this SQLite code?

2 Answers2