php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #7592 LIKE operator fails
Submitted: 2000-11-02 10:09 UTC Modified: 2000-11-02 13:27 UTC
From: frederic dot choquet at caramail dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.3pl1 OS: WinNT 4.0 WS
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: frederic dot choquet at caramail dot com
New email:
PHP Version: OS:

 

 [2000-11-02 10:09 UTC] frederic dot choquet at caramail dot com 
It seems impossible to use the SQL "LIKE" operator with ODBC/ACCESS 97.

ie:
$sqlstring = "SELECT Name FROM people WHERE Name LIKE \"A*\"";
$rst=odbc_exec($Conn, $sqlstring);

... may return the following err msg:

Impossible d'utiliser cette expression avec le pr?dicat LIKE. dans l'expression 'Name alike `A*`'

(sorry, it's in french, in english it may look like: Unable to use this expression with operator LIKE in expression 'Name alike `A*`')

What does this "alike" means?

If i echo $sqlstring, cut it and paste it directly to a query in Access, i got no err msg, so it is not a syntax error.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-11-02 13:27 UTC] waldschrott@php.net 
it?s SQL problems, not PHP problems, here - please only post
PHP bugs here

anyway, try this "... LIKE 'A%'"
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sun Jul 13 15:01:33 2025 UTC