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

(02-17-2016, 08:34 AM)keulu Wrote: did you try to escape your search ?

!Joker! -> \!Joker\!

The problem is only when the string starts with an '!', if the '!' is in the middle of the string or the end there is no problem.

(02-17-2016, 09:19 AM)Narf Wrote: What are the strings that are expected to match but don't?

Can always be different, users can search for usernames.
At the moment I have 1.441.321 usernames saved in my database.

But usernames like these give issues:
! Astro !
!!!
!Buddla!
!l †r€d¡(¡
!2
!f:g:g
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