Re: Howto search in SQL for a specific character?

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@thelonecoder.com> To: "Gustav Wiberg" <gustav@varupiraten.se>; "PHP General" <php-general@lists.php.net> Sent: Tuesday, November 29, 2005 10:00 PM Subject: Re: [PHP] 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@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