Hello,
I am transfering from Access to MySQL.
I use it for a bibliograhical database.
In bibliograhical data the \ signs stands for semantische opposition.
My problem is that a query like
select * from term where term=$term$
works with Access but fails in MySQL when a \ character is in the term field
In the manual I read this is of the fact that the \ is used as an escape
sign.
It says one can solve the problem with replacing \ with \\.
My question is how to solve this in the query, because I don't want to
change the values in the term field.
Something like
select replace(term, '\','\\') from term where term=replace('$term$','\','\\
)
I can't get it working.
Does anybody know how to solve this problem.
Niek van Baalen
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
