Posted by Stephen Johnson on 11/29/05 23:00

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@thelonecoder.com

continuing the struggle against bad code

*/
?>


> From: Gustav Wiberg <gustav@varupiraten.se>
> Organization: Gustav Wiberg
> Reply-To: Gustav Wiberg <gustav@varupiraten.se>
> Date: Tue, 29 Nov 2005 21:55:27 +0100
> To: PHP General <php-general@lists.php.net>
> Subject: [PHP] 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
>

• Next in forum: Re: [PHP] Howto search in SQL for a specific character?
• Prev in forum: RE: [PHP] Howto search in SQL for a specific character?
• Thread view: Re: [PHP] Howto search in SQL for a specific character?

[Reply to this message]