SQL migration from MySQL to PostgreSQL

From annawiki
Revision as of 2022-10-29T14:40:47 by Tobiasco (talk | contribs)
  1. change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then return an error in MySQL
  2. see also Postgresql vs Mysql