SQL migration from MySQL to PostgreSQL: Difference between revisions

Revision as of 2022-10-28T16:48:58

change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then fail in MySQL

Revision as of 2022-10-28T16:48:23 (view source) Tobiasco (talk \| contribs) (Created page with "#change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is")		Revision as of 2022-10-28T16:48:58 (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		#change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then fail in MySQL