Hi
I'm sorry but this didn't work either? If I replaced the ' with for example
an a it worked
/G
----- Original Message -----
From: "Stephen Johnson" <maillists@xxxxxxxxxxxxxxxx>
To: "Gustav Wiberg" <gustav@xxxxxxxxxxxxxx>; "PHP General"
<php-general@xxxxxxxxxxxxx>
Sent: Tuesday, November 29, 2005 10:00 PM
Subject: Re: Howto search in SQL for a specific character?
Try this :
$sql = "SELECT nameOfPedigree FROM tbpedigrees WHERE nameOfPedigree like
"'%";
The % is a wildcard and will give you the results you want.
<?php
/*
Stephen Johnson c | eh
The Lone Coder
http://www.ouradoptionblog.com
Join our journey of adoption
http://www.thelonecoder.com
stephen@xxxxxxxxxxxxxxxx
continuing the struggle against bad code
*/
?>
From: Gustav Wiberg <gustav@xxxxxxxxxxxxxx>
Organization: Gustav Wiberg
Reply-To: Gustav Wiberg <gustav@xxxxxxxxxxxxxx>
Date: Tue, 29 Nov 2005 21:55:27 +0100
To: PHP General <php-general@xxxxxxxxxxxxx>
Subject: Howto search in SQL for a specific character?
Hi there!
in PHP i Write..
$v1 = chr(39); //39 is apostrofe
$sql = "SELECT nameOfPedigree FROM tbpedigrees WHERE
SUBSTR(nameOfPedigree,0,1) = $v1";
Why doesn't this work?
I want the sql to select all nameOfPedigree - fields where the first
character is apostrofe (')
/G
http://www.varupiraten.se/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
