Category: MySQL

Escaping meta characters in PHP

I was surprised to discover that the MySQL query SELECT * WHERE name LIKE “%AFA_”; returns rows where name is SAFARI. To get it to match...

Syntax LEFT JOIN 3 MySQL Tables

I’m struggling hard with this SQL query. I’m trying to LEFT JOIN 3 tables. Is the following syntax for LEFT JOINING 3 tables basically right? SELECT...