SQL migration from MySQL to PostgreSQL: Difference between revisions

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

Revision as of 2022-10-28T16:48:58 (view source) Tobiasco (talk \| contribs) No edit summary ← Older edit		Revision as of 2022-10-28T16:49:11 (view source) Tobiasco (talk \| contribs) No edit summary Newer edit →
Line 1:		Line 1:
	#change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then ~~fail~~ in MySQL		#change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then return an error in MySQL