MySQLisms

File				Line	Problem or idiom to look at
C4/Barcodes/annual.pm		41	substring_index()
C4/Creators/Lib.pm		359	CONCAT_WS()
C4/Reports/Guided.pm		178	"SHOW TABLES"
C4/Reports/Guided.pm		214	"show columns from $tablename"
C4/Reports/Guided.pm		569ff	DATE()
C4/Accounts.pm			606	TIMESTAMP()
C4/Auth.pm			141	FROM_UNIXTIME()
C4/AuthoritiesMarc.pm		1256	"UPDATE IGNORE auth_header set ..."
C4/Biblio.pm			2760	"LOCK TABLES nozebra WRITE, ..."
C4/Biblio.pm			2786	"UNLOCK TABLES"
C4/Biblio.pm			3831	"... OR datecancellationprinted='0000-00-00')"
C4/Bookseller.pm		110	"DATE_SUB(CURDATE() ..."
C4/Calendar.pm			95	"ISNULL(weekday) ..."
C4/Calendar.pm			504	"WEEKDAY(CONCAT(...))"
C4/Circulation.pm		2161ff	TO_DAYS()
C4/Circulation.pm		3007	"TRUNCATE TABLE ..."
C4/Context.pm			530	ON DUPLICATE KEY UPDATE
C4/ImportExportFramework.pm	269	SHOW COLUMNS FROM
C4/ImportExportFramework.pm	308	SHOW COLUMNS FROM
C4/ImportExportFramework.pm	364	SHOW COLUMNS FROM
C4/ImportExportFramework.pm	430	SHOW COLUMNS FROM
C4/ImportExportFramework.pm	953	SHOW COLUMNS FROM
C4/ImportExportFramework.pm	1007	SHOW COLUMNS FROM
C4/ImportExportFramework.pm	1047	ON DUPLICATE KEY UPDATE
C4/Installer.pm			428	"INSERT IGNORE INTO `systempreferences` ..."
C4/Items.pm			2064ff	"INSERT INTO item SET ..."
C4/Items.pm			2285	"INSERT INTO deleteditems SET "
C4/Letters.pm			543	SHOW COLUMNS FROM
C4/Log.pm			215ff	DATE_FORMAT()
C4/Members.pm			688	SHOW COLUMNS FROM
C4/Members.pm			862	substring(str, from, to)
C4/Members.pm			1806	INSERT INTO ... ON DUPLICATE KEY UPDATE ..."
C4/NewsChannels.pm		144ff	CURRENT_DATE()
C4/Overdues.pm			127	CURDATE()
C4/Overdues.pm			135	CURDATE()
C4/Overdues.pm			140ff	TO_DAYS()
C4/Overdues.pm			1221	CURDATE()
C4/Reserves.pm			269	CURRENT_DATE()
C4/Reserves.pm			335	CURRENT_DATE()
C4/Reserves.pm			865	DATE(), DATE(CURDATE())
C4/Reserves.pm			1601	CURRENT_DATE()
C4/Reserves.pm			1631	CURRENT_DATE()
C4/Reserves.pm			1662	CURRENT_DATE()
C4/Search.pm			1462	SHOW COLUMNS FROM items
C4/Search.pm			1899	"WHERE ... LIKE CONCAT(.., '%')"
C4/Serials.pm			382	IF(serial.publisheddate=00-00-0000", ...)
C4/Serials.pm			524	year(IF(...
C4/Serials.pm			544	IF(...)
C4/Serials.pm			657	ORDER BY IF(a, b, c)
C4/Serials.pm			678	ORDER BY IF()
C4/SQLHelper.pm			252	SHOW COLUMNS FROM $tablename
C4/Suggestions.pm		157	format_date_in_iso
C4/Suggestions.pm		456	ADDDATE(NOW(), ...)
C4/Tags.pm			144ff	DELETE ... LIMIT 1