[Pugged] \Z

[Dave J. Hala Jr.]

I've got a bunch of fields in a mysql database that have a \Z character
in them.  I want to search a field for \Z and if it contains that
character, make the field blank.  

In running php 4.x on RH 8.0

Here is the code:

	$connection = db_connect("Could not connect  DB");
	$SQL="SELECT id,PVLN from lhpl_side WHERE PVLN =\"\\Z\" ";
	$result= mysql_query($SQL,$connection) or die (mysql_error());
	$num = mysql_numrows($result);

This query returns 0 rows. (no error messages either) But when I execute
the query: 
SELECT id,PVLN from lhpl_side WHERE PVLN ="\Z"; from the mysql command
prompt it works properly. (returns a 172 rows)

I realize that I need to do an update to change the value in field.
However, right now I just need to get a query to find the fields to
work.

Anyone got any ideas?
 

:) Dave
-- 

"...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and
the Ugly)"

OSIS
Dave J. Hala Jr.
641.485.1606