sqlmock for select query with and without regex

sqlmock_test.go

// with empty New(), you should use regex `(.+)` and escape the `$` using `\\`
db, mock, _ := sqlmock.New()
	mock.ExpectQuery("SELECT (.+) FROM \"ARTICLES\" WHERE \"SLUG\" = \\$1").
		WithArgs("foobar").
		WillReturnRows(
			sqlmock.NewRows(columns).AddRow(
				"28e8a227-4ebd-43b8-9631-108392ed2ba8",
				"foobar",
				"Foobar",
				"Body foobar",
				time.Now(),
				time.Now(),
			),
		)

// if you not use regex `(.+)` add `sqlmock.QueryMatcherOption(sqlmock.QueryMatcherEqual)` in `New()`
db, mock, _ := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherEqual))
	mock.ExpectQuery(`SELECT * FROM "ARTICLES" WHERE "SLUG" = $1`).
		WithArgs("foobar").
		WillReturnRows(
			sqlmock.NewRows(columns).AddRow(
				"28e8a227-4ebd-43b8-9631-108392ed2ba8",
				"foobar",
				"Foobar",
				"Body foobar",
				time.Now(),
				time.Now(),
			),
		)