SQL migration from MySQL to PostgreSQL: Difference between revisions

Revision as of 2022-10-28T14: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-28T14:48:23 view source Tobiasco (talk \| contribs) Bureaucrats, Interface administrators, Administrators 9,768 edits Created page with "#change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is"		Revision as of 2022-10-28T14:48:58 view source Tobiasco (talk \| contribs) Bureaucrats, Interface administrators, Administrators 9,768 edits 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