Welcome Guest, Not a member yet? Register   Sign In
MySql LIKE
#7

(02-17-2016, 11:27 AM)Narf Wrote:
Quote:mysql> create table test (dummy varchar(16) not null);
Query OK, 0 rows affected (0.10 sec)

mysql> insert into test(dummy) values ('!exclamation');
Query OK, 1 row affected (0.06 sec)

mysql> select dummy from test where dummy like '%!!%' escape '!';
+--------------+
| dummy        |
+--------------+
| !exclamation |
+--------------+
1 row in set (0.00 sec)

It should work ...

Over 1 million usernames and this query gives 0 result:
Code:
SELECT *
FROM `pvp_map`
WHERE `Name` LIKE '%!!%' ESCAPE '!'
GROUP BY `Player_Id`, `Name`
ORDER BY `Name`

I really don't know where the problem is.
Reply


Messages In This Thread
MySql LIKE - by glennm - 02-15-2016, 02:32 PM
RE: MySql LIKE - by glennm - 02-17-2016, 08:27 AM
RE: MySql LIKE - by keulu - 02-17-2016, 08:34 AM
RE: MySql LIKE - by Narf - 02-17-2016, 09:19 AM
RE: MySql LIKE - by glennm - 02-17-2016, 10:59 AM
RE: MySql LIKE - by Narf - 02-17-2016, 11:27 AM
RE: MySql LIKE - by glennm - 02-17-2016, 11:39 AM
RE: MySql LIKE - by glennm - 02-17-2016, 11:53 AM
RE: MySql LIKE - by Narf - 02-17-2016, 12:12 PM
RE: MySql LIKE - by glennm - 02-17-2016, 12:22 PM
RE: MySql LIKE - by skunkbad - 02-17-2016, 03:51 PM
RE: MySql LIKE - by glennm - 02-17-2016, 05:53 PM
RE: MySql LIKE - by skunkbad - 02-17-2016, 09:00 PM
RE: MySql LIKE - by Narf - 02-18-2016, 02:48 AM
RE: MySql LIKE - by glennm - 02-18-2016, 04:30 AM



Theme © iAndrew 2016 - Forum software by © MyBB