note 101859 added to function.mysql-query
| From: | radu at osu1 dot php dot net | Date: | Fri, 14 Jan 2011 15:05:50 +0000 |
| Subject: | note 101859 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-175745@lists.php.net to get a copy of this message | ||
Hi guys,
Try this: (in phpmyadmin or directly in mysql console):
SELECT * FROM
a_table WHERE a_column REGEXP '(\\\\)'
this, works fine if ran like that - the query searches in a_table the rows where
a_column contains a "\" character.
however, if I run this query using mysql_query (I also tried with adodb) it gives me :
Got error 'parentheses not balanced' from regexp1
----
Server IP: 69.147.83.197
Probable Submitter: 89.44.154.35
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- https://master.php.net/note/edit/101859
Del: integrated -- https://master.php.net/note/delete/101859/integrated
Del: useless -- https://master.php.net/note/delete/101859/useless
Del: bad code -- https://master.php.net/note/delete/101859/bad+code
Del: spam -- https://master.php.net/note/delete/101859/spam
Del: non-english -- https://master.php.net/note/delete/101859/non-english
Del: in docs -- https://master.php.net/note/delete/101859/in+docs
Del: other reasons-- https://master.php.net/note/delete/101859
Reject -- https://master.php.net/note/reject/101859
Search -- https://master.php.net/manage/user-notes.php