Re: Howto search in SQL for a specific character?
| From: | Stephen Johnson | Date: | Tue, 29 Nov 2005 21:00:24 +0000 |
| Subject: | Re: Howto search in SQL for a specific character? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-226605@lists.php.net to get a copy of this message | ||
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
>