SQL migration from MySQL to PostgreSQL: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
#change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then | #change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then return an error in MySQL |
Revision as of 2022-10-28T16:49:11
- change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then return an error in MySQL