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
