Hey folks,
I am moving a website from MSAccess to MySQL. WHat started out as a fairly low
traffic site has grown and I appear to be bumping against the connection limits
of MSAccess.
I have some very odd queries in the site, which I inherited from a previous
developer, due to the table structu
& is the concatenation operator in MS Access. MySQL doesn't have such
an operator, it has the CONCAT() function instead. It takes as many
parameters as you need, and returns them all concatenated together, as
you'd expect.
and ',' & myfieldname & ',' LIKE '%,myvalue,%'
becomes
and CONCAT(',',
2 matches
Mail list logo