LIKE (MySQL): verschil tussen versies

Huidige versie van 27 aug 2022 om 13:50

Het sleutelwoord like biedt beperke mogelijkheden voor patroonherkenning in select queries. Bv.:

SELECT * FROM pet WHERE name LIKE 'b%';

This doesn't seem to work:

select
   *
from
   wp_term_taxonomy
where
   description like "%é%";

'é' seems to be a double-byte character. I forgot now what it was
When I update a field through MySQL Workbench, it formed tan SQL statement containing 'é', rather than escaping it somehow

Quick-and-dirty hack: Replace "é" with "e" before doing more advanced stuff that involves LIKE.

@@ Regel 3: / Regel 3: @@
   SELECT * FROM pet WHERE name LIKE 'b%';
-== Casus: Problemen met non-ASCII characters? (2022.08) ==
+== Escaping ==
-Dit lijkt niet te werken:
+See case 2022.08 below + https://stackoverflow.com/questions/7343658/like-in-mysql-with-special-character → Learn to love backslashes, it seems.
+== Case: Problem with non-ASCII characters? (2022.08) ==
+This doesn't seem to work:
 <pre>
@@ Regel 16: / Regel 20: @@
 </pre>
-Het lijkt om karakter <code>6d</code> - 109 te gaan.
+* 'é' seems to be a double-byte character. I forgot now what it was
+* When I update a field through MySQL Workbench, it formed tan SQL statement containing 'é', rather than escaping it somehow
+Quick-and-dirty hack: Replace "é" with "e" before doing more advanced stuff that involves LIKE.
+== See also ==
+* [[String delimiters (MySQL)]]
 == Bronnen ==
 * http://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
-wp_term_taxonomy
+* https://stackoverflow.com/questions/7343658/like-in-mysql-with-special-character
+* https://stackoverflow.com/questions/881194/how-do-i-escape-special-characters-in-mysql