LIKE (MySQL)
Naar navigatie springen
Naar zoeken springen
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Het sleutelwoord like
biedt beperke mogelijkheden voor patroonherkenning in select queries. Bv.:
SELECT * FROM pet WHERE name LIKE 'b%';
Escaping
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:
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.