MySql LIKE

MySql LIKE

glennm
Junior Member
Posts: 17
Threads: 4
Joined: Jan 2016
Reputation: 0

02-17-2016, 10:59 AM

(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

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