SELECT .... LIKE ("%_%") not returning any results

npd1164

Query

SELECT pg_id FROM pages WHERE pg_content LIKE ("%INSERT_THIS=[1%")

Example pg_content:

This is some text with an special tag INSERT_THIS=[1,2,3] stuck right in the middle of the sentence.

I'm guessing it's due to the bracket in the query but I'm not sure if its an escaping issue, or what.
Any ideas?

bradgrafelman

Worked fine for me:

mysql> CREATE TABLE foo (
    ->     test VARCHAR(200)
    -> );
Query OK, 0 rows affected (0.37 sec)

mysql> INSERT INTO foo VALUES
    -> ('This is some text with an special tag INSERT_THIS=[1,2,3] stuck right in the middle of the sentence.'),
    -> ('This is some text with an special tag INSERT_THIS=[4,5,6] stuck right in the middle of the sentence.')
    -> ;
Query OK, 2 rows affected (0.03 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> SELECT test FROM foo WHERE test LIKE '%INSERT_THIS=[1%';
+-------------------------------------------------------------------------------
-----------------------+
| test
                       |
+-------------------------------------------------------------------------------
-----------------------+
| This is some text with an special tag INSERT_THIS=[1,2,3] stuck right in the middle of the sentence. |
+-------------------------------------------------------------------------------
-----------------------+
1 row in set (0.02 sec)

npd1164

Thanks for the quick response.

Might there be a difference between your command line terminal test vs a similar query posed via an app like Querious?

If I leave the bracket out of my query, the results come up fine.

This works for me:  SELECT test FROM foo WHERE test LIKE '%INSERT_THIS=%';
But this does not:  SELECT test FROM foo WHERE test LIKE '%INSERT_THIS=[1%';

dalecosp

I'm not familiar with the app, but it could be so, if the developers of Querious were %derogatory_term% enough to munge your inputs. :eek:

Mac OS has a terminal, and probably has the mysql client available there. Try it in the terminal the way Brad shows above and you might get a answer for the question?